Questions tagged [oracle-database]

30

votes

2

answers

Execute Statement or Run Script?

asked 2009-01-26T10:58:09.917

227

votes

28

answers

How can I get column names from a table in Oracle?

sql database oracle-database

asked 2009-01-16T23:53:00.937

46

votes

7

answers

System.Data.OracleClient requires Oracle client software version 8.1.7

vb.net oracle-database

asked 2009-01-15T18:54:50.077

46

votes

4

answers

How to catch a unique constraint error in a PL/SQL block?

oracle-database plsql

asked 2009-01-13T18:17:46.390

30

votes

6

answers

What is the difference between a temporary table vs global temporary table in Oracle?

database oracle-database temp-tables

asked 2009-01-06T19:22:23.527

9

votes

7

answers

Session based global variable in Postgresql stored procedure?

oracle-database postgresql plsql plpgsql

asked 2009-01-05T21:09:59.457

135

votes

11

answers

How to put more than 1000 values into an Oracle IN clause

oracle-database in-clause

asked 2008-12-30T13:35:17.673

40

votes

7

answers

ORA-12638: Credential retrieval failed

oracle-database

asked 2008-12-18T20:37:22.777

16

votes

2

answers

oracle left outer joins not showing right null values

oracle-database join

asked 2008-12-12T11:58:57.590

23

votes

3

answers

Oracle: How do I get the sequence number of the row just inserted?

sql oracle-database

asked 2008-12-11T22:49:36.663

17

votes

13

answers

Trying to connect internally to Oracle, getting an idle instance?

oracle-database instance idle-processing

asked 2008-12-08T15:36:58.050

22

votes

6

answers

Execution order of conditions in SQL 'where' clause

sql oracle-database where-clause

asked 2008-12-04T10:26:10.973

23

votes

9

answers

Auto-increment in Oracle without using a trigger

oracle-database triggers auto-increment sequences

asked 2008-11-25T11:04:26.577

16

votes

8

answers

IDE for Pl/SQL development

oracle-database debugging plsql

asked 2008-11-20T09:05:57.177

21

votes

3

answers

PL/SQL: How do I declare session variables?

oracle-database plsql

asked 2008-11-19T09:24:09.840

10

votes

2

answers

Access Web service from Oracle stored procedure

java oracle-database web-services stored-procedures plsql

asked 2008-11-18T15:08:43.200

18

votes

4

answers

Find out name of PL/SQL procedure

oracle-database plsql

asked 2008-11-13T08:45:26.697

16

votes

7

answers

JDBC - Oracle ArrayIndexOutOfBoundsException

oracle-database jdbc jboss

asked 2008-11-10T12:22:10.987

47

votes

11

answers

How to find out when an Oracle table was updated the last time

oracle-database oracle-call-interface

asked 2008-11-05T13:26:03.137

114

votes

7

answers

What is the difference between "AS" and "IS" in an Oracle stored procedure?

oracle-database stored-procedures keyword

asked 2008-10-23T16:11:11.980

35

votes

6

answers

How to choose and optimize oracle indexes?

oracle-database optimization indexing

asked 2008-10-17T14:01:59.233

16

votes

22

answers

Oracle ORA-12154: TNS: Could not resolve service name Error?

oracle-database odbc tns

asked 2008-10-15T19:23:14.140

1234

votes

25

answers

Get list of all tables in Oracle?

sql oracle-database

asked 2008-10-15T17:54:49.387

52

votes

4

answers

How to use enums in Oracle?

database oracle-database enums

asked 2008-10-15T01:48:37.780

24

votes

10

answers

Unit Testing Framework for Oracle PL/SQL?

sql oracle-database unit-testing plsql

asked 2008-10-15T00:58:07.630

10

votes

3

answers

What is the syntax to use a Select statement inside a PL/SQL Trigger?

sql oracle-database plsql ora-00923

asked 2008-10-14T20:12:05.057

68

votes

4

answers

How do I show running processes in Oracle DB?

oracle-database process

asked 2008-10-14T00:04:52.810

52

votes

11

answers

Determine Oracle null == null

sql oracle-database null nullable

asked 2008-10-10T14:37:54.843

47

votes

6

answers

Grant Select on all Tables Owned By Specific User

oracle-database

asked 2008-10-09T15:44:29.963

14

votes

3

answers

What is the size limit for a varchar2 PL/SQL subprogram argument in Oracle?

oracle-database plsql

asked 2008-10-09T08:26:10.113

75

votes

2

answers

What do the letter codes in Oracle user_contraints table's constraint_type column stand for?

oracle-database constraints oracleinternals

asked 2008-10-08T16:26:35.103

17

votes

9

answers

ORA-01438: value larger than specified precision allows for this column

sql database oracle-database plsql ora-01438

asked 2008-10-08T04:30:11.650

28

votes

1

answers

How to disable Oracle XE component which is listening on 8080?

oracle-database oracle-xe

asked 2008-10-02T23:49:33.317

13

votes

6

answers

Code coverage for PL/SQL

oracle-database plsql

asked 2008-09-30T09:55:14.073

99

votes

11

answers

Oracle: is there a tool to trace queries, like Profiler for SQL Server?

sql-server oracle-database profiler

asked 2008-09-29T13:31:19.037

11

votes

2

answers

ORA-01031: insufficient privileges when creating package

sql oracle-database package

asked 2008-09-27T17:38:54.623

17

votes

7

answers

Any performance impact in Oracle for using LIKE 'string' vs = 'string'?

sql performance oracle-database

asked 2008-09-25T16:46:35.850

32

votes

6

answers

Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?

oracle-database jboss connection-pooling reconnect

asked 2008-09-24T17:30:40.247

28

votes

11

answers

How to avoid storing credentials to connect to Oracle with JDBC?

oracle-database jdbc credentials

asked 2008-09-24T12:05:22.773

309

votes

19

answers

Inner join vs Where

sql performance oracle-database

asked 2008-09-23T15:13:28.040

10

votes

2

answers

How to restrict NULL input parameters into oracle stored procedure

oracle-database stored-procedures

asked 2008-09-22T18:15:00.517

19

votes

5

answers

SQLPlus settings to generate tab-separated data file

oracle-database tabs sqlplus

asked 2008-09-19T23:14:23.723

174

votes

12

answers

How can I confirm a database is Oracle & what version it is using SQL?

sql oracle-database

asked 2008-09-19T11:27:01.467

47

votes

5

answers

How to return multiple rows from the stored procedure? (Oracle PL/SQL)

sql oracle-database plsql

asked 2008-09-19T10:46:48.460

11

votes

5

answers

how to replace multiple strings together in Oracle

oracle-database string replace

asked 2008-09-17T14:31:29.590

10

votes

13

answers

Best practices for holding passwords in shell / Perl scripts?

perl oracle-database bash ksh

asked 2008-09-17T06:50:46.000

94

votes

11

answers

How do you interpret a query's explain plan?

sql database performance oracle-database sql-execution-plan

asked 2008-09-17T02:26:18.930

13

votes

6

answers

How do you know what a good index is?

database oracle-database indexing

asked 2008-09-17T02:22:41.527

23

votes

9

answers

How often should Oracle database statistics be run?

database performance oracle-database statistics

asked 2008-09-17T02:20:48.630

28

votes

16

answers

What is the difference between explicit and implicit cursors in Oracle?

oracle-database plsql

asked 2008-09-16T16:06:52.083

Questions tagged oracle-database