Alex Rivera | Logout

Questions tagged oracle-database

513 questions · page 9 of 11

Sort by: Newest Votes Active
14
votes
5
answers

Is there integer ranges for Where Clause?

sql oracle-database
asked 2009-07-16T13:51:19.797
105
votes
8
answers

Oracle SQL escape character (for a '&')

sql oracle-database escaping oracle-sqldeveloper
asked 2009-07-16T12:50:17.263
9
votes
2
answers

Oracle CASE with OR

oracle-database plsql
asked 2009-07-08T18:38:03.883
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
27
votes
12
answers

Hidden features of PL/SQL

sql oracle-database plsql
asked 2009-06-23T09:20:03.967
37
votes
8
answers

How to find Current open Cursors in Oracle

oracle-database oracle10g database-cursor
asked 2009-06-18T05:25:22.247
12
votes
5
answers

Oracle EXECUTE IMMEDIATE with variable number of binds possible?

oracle-database plsql dynamic-sql
asked 2009-06-17T15:45:04.147
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
12
votes
7
answers

How to iterate over a date range in PL/SQL

sql database oracle-database plsql
asked 2009-06-12T16:21:38.660
27
votes
8
answers

Bulk Insert into Oracle database: Which is better: FOR Cursor loop or a simple Select?

sql oracle-database plsql
asked 2009-06-12T14:44:58.687
36
votes
5
answers

Oracle Pl/SQL: Loop through XMLTYPE nodes

xml oracle-database plsql xmltype
asked 2009-06-12T09:49:12.877
27
votes
6
answers

Oracle 11g SQL to get unique values in one column of a multi-column query

sql oracle-database distinct
asked 2009-06-11T19:42:31.943
14
votes
3
answers

C# Oracle Stored Procedure Parameter Order

c# oracle-database stored-procedures
asked 2009-06-06T08:20:11.863
251
votes
8
answers

Oracle Differences between NVL and Coalesce

sql oracle-database coalesce nvl
asked 2009-06-04T11:58:54.610
10
votes
9
answers

When is sql distinct faster than java programming 'distinct'

java sql database performance oracle-database
asked 2009-06-04T10:37:28.253
17
votes
3
answers

Is there a way to view relationships in Oracle SQL Developer?

database oracle-database
asked 2009-05-29T14:57:46.607
37
votes
4
answers

What is the minimal setup required to deploy a .NET application with Oracle client 11?

oracle-database odp.net
asked 2009-05-28T21:23:47.047
12
votes
8
answers

Which CEP product to start with?

oracle-database esper complex-event-processing
asked 2009-05-26T18:32:05.017
27
votes
5
answers

Abort a PL/SQL program

oracle-database plsql
asked 2009-05-21T05:06:54.857
194
votes
6
answers

Number of rows affected by an UPDATE in PL/SQL

oracle-database plsql sql-update
asked 2009-05-14T07:21:22.210
37
votes
6
answers

SQL to search objects, including stored procedures, in Oracle

sql oracle-database search full-text-search
asked 2009-05-12T16:01:03.893
28
votes
9
answers

SQL: delete all the data from all available tables

sql oracle-database
asked 2009-05-06T22:41:40.327
14
votes
2
answers

Oracle connection string without tnsnames.ora file

.net asp.net oracle-database connection-string oracleclient
asked 2009-05-04T14:50:54.360
30
votes
7
answers

Free desktop client for Oracle?

database oracle-database desktop-application
asked 2009-05-04T13:24:28.797
55
votes
6
answers

Oracle: sequence MySequence.currval is not yet defined in this session

oracle-database sequence
asked 2009-04-30T21:41:37.760
43
votes
9
answers

Does the order of tables referenced in the ON clause of the JOIN matter?

sql mysql sql-server oracle-database
asked 2009-04-24T12:09:18.763
15
votes
4
answers

How to configure Ruby on Rails with Oracle?

ruby-on-rails ruby oracle-database
asked 2009-04-19T05:28:31.153
10
votes
3
answers

How to get all tables that have FKs to another table?

oracle-database foreign-keys
asked 2009-04-08T19:10:15.307
49
votes
6
answers

Stored Procedure with optional "WHERE" parameters

sql mysql sql-server oracle-database
asked 2009-03-30T15:21:42.347
9
votes
10
answers

Does SELECT DISTINCT imply a sort of the results

sql oracle-database sqlplus
asked 2009-03-27T21:39:29.890
43
votes
12
answers

oracle diff: how to compare two tables?

oracle-database diff
asked 2009-03-27T04:16:58.510
173
votes
18
answers

How do I spool to a CSV formatted file using SQLPLUS?

sql oracle-database csv sqlplus
asked 2009-03-13T15:05:29.210
15
votes
2
answers

Oracle SYS_GUID does not change

oracle-database guid
asked 2009-03-13T10:14:55.430
10
votes
9
answers

SQL not equals & null

sql performance oracle-database
asked 2009-03-12T00:14:02.210
13
votes
6
answers

What Situations Cause Oracle Packages to Become Invalid?

oracle-database plsql package dependencies
asked 2009-03-09T13:37:48.747
112
votes
10
answers

How to check Oracle database for long running queries

oracle-database
asked 2009-03-07T18:43:40.247
90
votes
7
answers

What is the default Precision and Scale for a Number in Oracle?

database oracle-database number-formatting
asked 2009-02-27T01:22:51.313
33
votes
9
answers

Sum columns with null values in oracle

sql oracle-database
asked 2009-02-26T13:30:50.900
25
votes
9
answers

Can We use threading in PL/SQL?

oracle-database asynchronous plsql
asked 2009-02-23T07:35:08.657
13
votes
6
answers

Moving Data from SQL Server to Oracle Repeatedly

sql-server database oracle-database
asked 2009-02-20T20:10:59.757
61
votes
2
answers

What exactly do quotation marks around the table name do?

sql oracle-database
asked 2009-02-18T22:12:14.503
9
votes
2
answers

Fluent NHibernate - how to configure for oracle?

oracle-database nhibernate fluent-nhibernate
asked 2009-02-18T21:31:36.160
9
votes
8
answers

Does making a primary key in multiple columns generate indexes for all of them?

oracle-database indexing primary-key multiple-columns
asked 2009-02-10T12:04:21.953
209
votes
24
answers

Removing duplicate rows from table in Oracle

sql oracle-database duplicates delete-row
asked 2009-02-09T17:34:43.987
22
votes
5
answers

How do I test if a column equals empty_clob() in Oracle?

oracle-database clob
asked 2009-02-06T18:15:50.333
33
votes
2
answers

How do I use the current date in an HQL query with an Oracle database?

oracle-database hibernate hql
asked 2009-02-04T20:58:37.107
18
votes
9
answers

SQL Plus change current directory

oracle-database sqlplus
asked 2009-02-03T21:47:33.763
13
votes
8
answers

DESCRIBE via database link?

sql oracle-database
asked 2009-01-30T13:18:13.467
← Prev page 9 of 11 Next →