Questions tagged [oracle10g]

11

votes

4

answers

Oracle Database import .sql file by command prompt

asked 2013-07-18T12:14:10.593

25

votes

3

answers

How to increase dbms_output buffer?

sql oracle-database plsql oracle10g dbms-output

asked 2013-05-10T06:39:37.057

99

votes

9

answers

How to find the privileges and roles granted to a user in Oracle?

oracle-database security oracle10g user-accounts

asked 2013-02-25T11:55:51.007

20

votes

7

answers

Concatenate results from a SQL query in Oracle

sql oracle-database oracle10g concatenation

asked 2013-01-09T17:36:55.290

12

votes

2

answers

How to return primary key from oracle merge query

oracle-database merge oracle10g sequence sql-returning

asked 2012-11-06T12:53:51.227

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

14

votes

4

answers

Oracle: Concat with delimiter, but only if both operands are NOT NULL

oracle-database oracle10g concatenation

asked 2012-07-12T14:32:16.357

33

votes

2

answers

How to get datetime in 24hour format from oracle database?

oracle10g

asked 2012-04-04T13:17:56.107

9

votes

2

answers

Use regexp_instr to get the last number in a string

regex oracle-database oracle10g

asked 2012-03-18T03:06:59.190

17

votes

4

answers

How to calculate the slope in SQL

mysql sql oracle10g

asked 2012-01-31T18:16:59.010

12

votes

2

answers

How to see refcursor result/output in Oracle SQL Developer?

oracle-database plsql oracle10g oracle-sqldeveloper ref-cursor

asked 2011-12-22T22:38:32.647

32

votes

4

answers

Pivoting rows into columns dynamically in Oracle

sql oracle-database oracle10g pivot

asked 2011-10-11T17:36:42.257

26

votes

2

answers

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

oracle-database oracle10g oracle11g sqlplus

asked 2011-10-09T01:27:21.020

9

votes

3

answers

ORACLE : Io exception: The Network Adapter could not establish the connection

linux jdbc oracle10g

asked 2011-09-06T17:59:24.080

34

votes

6

answers

Oracle Date TO_CHAR('Month DD, YYYY') has extra spaces in it

sql oracle-database oracle10g

asked 2011-08-23T19:27:38.540

13

votes

2

answers

Compiling Stored Procedure hangs Oracle SQL Developer

stored-procedures oracle10g compilation oracle-sqldeveloper

asked 2011-07-23T11:33:29.563

10

votes

5

answers

display select results inside anonymous block

oracle-database plsql oracle10g oracle-sqldeveloper pls-00428

asked 2011-06-23T14:19:49.427

19

votes

7

answers

Oracle - How to obtain information on index fields etc

plsql oracle10g

asked 2011-03-23T17:58:15.413

10

votes

3

answers

Oracle Unique Constraint with Expression

sql oracle-database oracle10g

asked 2011-01-10T15:28:01.273

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

13

votes

5

answers

Ways to escape single quotes in SQL 'LIKE' command

sql sql-server-2005 mysql oracle10g

asked 2010-08-17T15:48:35.187

19

votes

2

answers

How does contains() in PL-SQL work?

sql oracle-database oracle10g contains

asked 2010-03-12T07:11:29.890

23

votes

3

answers

JPA primary key auto generate

java hibernate orm jpa oracle10g

asked 2009-11-30T02:46:39.853

17

votes

2

answers

Migrating Oracle DATE columns to TIMESTAMP with timezone

sql oracle-database date oracle10g timestamp

asked 2009-11-03T00:54:20.980

9

votes

3

answers

Does Oracle roll back the transaction on an error?

sql oracle-database transactions plsql oracle10g

asked 2009-09-23T19:32:35.180

17

votes

5

answers

Should an Oracle database have more than one tablespace for data storage?

oracle-database oracle10g tablespace

asked 2009-08-18T01:11:38.717

22

votes

4

answers

PL/SQL Logging - How to control?

oracle-database plsql oracle10g instrumentation

asked 2009-08-05T09:55:40.430

13

votes

2

answers

Granting "Create Directory" Privileges in Oracle

oracle-database oracle10g

asked 2009-06-29T14:50:13.977

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

23

votes

4

answers

Relation between Oracle session and connection pool

oracle-database oracle10g connection websphere

asked 2009-06-24T17:00:09.243

37

votes

8

answers

How to find Current open Cursors in Oracle

oracle-database oracle10g database-cursor

asked 2009-06-18T05:25:22.247

24

votes

7

answers

Resolving ORA-4031 "unable to allocate x bytes of shared memory"

oracle-database memory-management oracle10g

asked 2009-06-15T01:07:19.940

36

votes

4

answers

How do I clear oracle execution plan cache for benchmarking?

sql oracle10g

asked 2009-05-13T16:03:38.420

Questions tagged oracle10g