Questions tagged [oracle11g]

11

votes

4

answers

Oracle Database import .sql file by command prompt

asked 2013-07-18T12:14:10.593

14

votes

3

answers

How to update cursor limit for ORA-01000: maximum open cursors exceed

oracle11g

asked 2013-05-21T18:21:29.493

13

votes

6

answers

ORA-01031 Insufficient privileges while CREATING a VIEW?

sql oracle-database view oracle11g

asked 2013-04-20T21:36:26.043

9

votes

1

answers

Defining size of CLOB in Oracle

sql oracle11g clob

asked 2013-04-05T22:08:28.067

11

votes

1

answers

Why cannot I create triggers on objects owned by SYS?

oracle-database plsql oracle11g database-trigger

asked 2013-03-13T04:54:27.670

8

votes

1

answers

get runtime execution plan of a query

oracle-database oracle11g

asked 2013-01-23T12:55:02.530

13

votes

2

answers

Java OracleDB connection taking too long the first time

java oracle11g redhat

asked 2013-01-18T14:06:41.777

8

votes

2

answers

Oracle XE 11g homepage not displaying

oracle-database installation oracle11g listener

asked 2013-01-18T12:22:20.240

8

votes

4

answers

Inner Join of three different Tables

sql oracle11g oracle-apex

asked 2013-01-10T09:31:36.293

9

votes

5

answers

how to find partition of record oracle

database oracle-database plsql oracle11g database-partitioning

asked 2012-12-01T13:35:20.010

32

votes

2

answers

When should I use 'for update nowait' in cursors?

oracle-database stored-procedures oracle11g oracle10g database-cursor

asked 2012-11-06T09:39:25.207

10

votes

3

answers

listunagg function?

string oracle-database csv oracle11g tokenize

asked 2012-11-02T05:02:47.703

9

votes

2

answers

What is the common sql for sysdate and getdate()

sql sql-server oracle11g

asked 2012-10-19T16:52:48.057

10

votes

2

answers

How to display a sys_refcursor data in TOAD's DataGrid

sql plsql oracle11g toad sys-refcursor

asked 2012-10-05T13:54:40.327

12

votes

1

answers

How to delete a column from a view

sql oracle-database oracle11g

asked 2012-09-30T10:11:22.750

8

votes

2

answers

Oracle User defined aggregate function for varray of varchar

oracle-database oracle11g aggregate-functions varray

asked 2012-09-02T15:34:39.657

18

votes

4

answers

what does order 1,2 do

sql oracle11g

asked 2012-06-28T08:25:39.090

13

votes

1

answers

Is there any way to determine if a package has state in Oracle?

oracle-database oracle11g package state

asked 2012-06-14T23:25:06.353

8

votes

9

answers

Using SQL LOADER in Oracle to import CSV file

sql csv oracle11g database-connection

asked 2012-05-31T19:15:18.987

18

votes

1

answers

ORA-00947 Not enough values while declaring type globally

oracle-database plsql oracle11g ora-00947

asked 2012-04-18T16:11:02.993

8

votes

2

answers

How efficiently does Oracle handle a very long IN operator list

sql oracle-database oracle11g

asked 2012-03-13T19:47:11.640

13

votes

2

answers

Large amount of projected I/O with Oracle, even if only a single record is fetched

sql performance oracle-database oracle11g sql-execution-plan

asked 2012-03-12T17:03:32.987

8

votes

1

answers

DBMS_XPLAN.DISPLAY_CURSOR vs Explain Plan if not using gather_plan_statistics hint

sql performance oracle-database oracle11g sql-execution-plan

asked 2012-02-22T03:49:18.657

10

votes

11

answers

TNS Protocol adapter error while starting Oracle SQL*Plus

oracle-database oracle11g sqlplus

asked 2012-01-09T00:49:31.200

36

votes

5

answers

How to declare and display a variable in Oracle

oracle-database plsql oracle11g

asked 2012-01-04T09:19:46.590

10

votes

2

answers

What type of join is '....where A.ID = B.ID (+)'

sql oracle-database join plsql oracle11g

asked 2011-11-30T16:18:11.680

104

votes

15

answers

Where does Oracle SQL Developer store connections?

oracle-database oracle11g

asked 2011-10-31T14:03:35.933

26

votes

2

answers

what does the "2"mean in SQL*Plus?

oracle-database oracle10g oracle11g sqlplus

asked 2011-10-09T01:27:21.020

10

votes

2

answers

Oracle 11g - Check constraint with RegEx

sql regex oracle-database oracle11g check-constraints

asked 2011-10-01T16:38:18.310

13

votes

2

answers

Oracle database is hanging infinitly in UPDATE queries

sql oracle-database transactions oracle11g

asked 2011-09-21T14:43:58.780

16

votes

4

answers

Oracle Sql get only month and year in date datatype

oracle11g

asked 2011-07-21T18:53:40.803

82

votes

3

answers

How to import an Oracle database from dmp file and log file?

oracle-database oracle11g oracle-dump

asked 2011-06-24T05:05:15.027

24

votes

1

answers

How to find available directory objects on Oracle 11g system?

oracle-database metadata oracle11g

asked 2011-06-14T14:39:33.037

10

votes

4

answers

How can I create and access multiple databases in Oracle 11g?

database oracle-database oracle11g database-schema

asked 2011-02-22T14:49:26.850

21

votes

5

answers

What does the (+) operator mean in a where-clause of PL/SQL?

sql oracle11g

asked 2011-01-08T07:54:31.077

17

votes

5

answers

Why doesn't Oracle raise "ORA-00918: column ambiguously defined" for this query?

sql oracle-database oracle10g oracle11g ora-00918

asked 2010-11-24T16:39:57.710

32

votes

2

answers

Oracle: Replacing non-numeric chars in a string

oracle11g replace

asked 2010-10-19T12:15:51.933

50

votes

5

answers

How to get rightmost 10 places of a string in oracle

sql oracle-database sorting oracle11g

asked 2010-10-08T06:59:07.390

12

votes

6

answers

Run Rails Tests without Dropping Test Database

ruby-on-rails unit-testing testing ruby-on-rails-3 oracle11g

asked 2010-09-22T14:15:48.890

11

votes

6

answers

Setting Oracle 11g Session Timeout

oracle-database oracle11g

asked 2010-07-29T15:01:53.210

23

votes

4

answers

Is there a way to give a subquery an alias in Oracle 11g SQL?

sql oracle-database subquery oracle11g table-alias

asked 2010-06-16T23:35:44.817

12

votes

2

answers

Oracle data provider pegs IIS worker process when web site is stopped

asp.net oracle-database iis oracle11g

asked 2010-05-06T15:16:10.747

51

votes

14

answers

Where to get this Java.exe file for a SQL Developer installation

oracle11g oracle-sqldeveloper

asked 2010-04-19T03:24:02.663

12

votes

3

answers

Table-Valued Functions in ORACLE 11g ? ( parameterized views )

oracle-database view oracle11g parameterized user-defined-functions

asked 2010-01-13T18:45:21.180

11

votes

4

answers

Oracle: Does a 10g oracle client work with an 11g server?

oracle-database oracle10g oracle11g

asked 2009-06-25T05:35:05.117

Questions tagged oracle11g