Alex Rivera | Logout

Questions tagged oracle-database

513 questions · page 3 of 11

Sort by: Newest Votes Active
9
votes
2
answers

SQL Loader Error: "Variable length field exceeds maximum length."

oracle-database sql-loader
asked 2012-04-30T15:13:10.460
22
votes
3
answers

DB2 database in Oracle SQL developer

database oracle-database db2 mainframe oracle-sqldeveloper
asked 2012-04-20T17:09:55.617
14
votes
3
answers

Unknown NullPointerException in JdbcOdbcDriver.finalize() line: 96

java oracle-database tomcat nullpointerexception jndi
asked 2012-04-20T13:51:34.100
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
20
votes
4
answers

Oracle SQL -- insert multiple rows into a table with one statement?

sql oracle-database insert
asked 2012-04-17T19:01:16.617
14
votes
2
answers

ResultSet - Cursor : rs.next() Taking lot of time

java oracle-database jdbc
asked 2012-04-10T09:03:13.513
9
votes
1
answers

How can I fetch the data from the SYS_REFCURSOR from one stored proc and use it in another?

sql oracle-database stored-procedures database-cursor
asked 2012-04-05T18:50:13.490
12
votes
1
answers

Good or bad idea to include numbers in SQL table names?

database oracle-database naming-conventions
asked 2012-03-29T13:40:07.413
8
votes
4
answers

Oracle Instant Client and Entity Framework trouble with configuration

c# asp.net-mvc oracle-database entity-framework odac
asked 2012-03-28T16:34:32.410
110
votes
11
answers

How to get records randomly from the Oracle database?

oracle-database select random
asked 2012-03-26T07:50:26.197
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
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
12
votes
2
answers

How do I create Oracle Type which refers to table columns for data type?

sql oracle-database user-defined-types
asked 2012-03-09T13:05:46.213
9
votes
3
answers

select distinct not working as expected

sql oracle-database
asked 2012-03-05T18:47:14.013
11
votes
3
answers

SQL: Get records created in time range for specific dates

sql oracle-database date-arithmetic
asked 2012-03-05T15:00:13.890
73
votes
4
answers

oracle - what statements need to be committed?

sql database oracle-database session commit
asked 2012-03-02T22:05:18.883
16
votes
6
answers

alternative to listagg in Oracle?

sql oracle-database varchar clob
asked 2012-02-23T11:51:56.453
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
1
answers

oracle distinct doing sort

sql oracle-database
asked 2012-02-14T16:30:22.367
26
votes
1
answers

Does Oracle automatically create a secondary index for FOREIGN KEY columns?

performance oracle-database indexing foreign-keys
asked 2012-02-13T15:18:06.837
38
votes
5
answers

How to persist LARGE BLOBs (>100MB) in Oracle using Hibernate

java oracle-database hibernate spring blob
asked 2012-02-12T22:29:08.220
16
votes
2
answers

Querying last 5 years

sql database oracle-database time
asked 2012-02-08T16:02:59.603
16
votes
3
answers

prevent sql injection in oracle "order by" part

sql oracle-database jdbctemplate
asked 2012-01-30T13:21:52.743
8
votes
1
answers

what does affect Oracle's determination of string expressions datatype?

oracle-database
asked 2012-01-26T11:33:03.457
11
votes
5
answers

Oracle client and networking components were not found

sql oracle-database ssis
asked 2012-01-25T12:16:45.577
10
votes
2
answers

How to correctly make a public synonym

oracle-database database-administration
asked 2012-01-24T22:18:35.610
8
votes
1
answers

Oracle and ADO.NET (The types in System.Data.OracleClient are deprecated.)

.net sql oracle-database
asked 2012-01-17T12:47:54.687
8
votes
2
answers

How does EXISTS work in Oracle, and how does it differ from IN?

sql oracle-database
asked 2012-01-16T03:00:02.390
9
votes
3
answers

How to get all executed SQL queries in ORACLE?

sql oracle-database
asked 2012-01-10T12:26:34.590
10
votes
11
answers

TNS Protocol adapter error while starting Oracle SQL*Plus

oracle-database oracle11g sqlplus
asked 2012-01-09T00:49:31.200
32
votes
2
answers

Example of an Oracle PIVOT clause with subquery

sql oracle-database syntax subquery pivot
asked 2012-01-06T15:11:58.270
30
votes
3
answers

Solution to "cannot perform a DML operation inside a query"?

sql oracle-database function stored-procedures plsql
asked 2012-01-04T15:20:16.100
36
votes
5
answers

How to declare and display a variable in Oracle

oracle-database plsql oracle11g
asked 2012-01-04T09:19:46.590
9
votes
2
answers

Print Record fields in PL/SQL

oracle-database plsql
asked 2012-01-03T19:01:35.617
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
8
votes
3
answers

plsql/cursors handle exception and return back to the execution flow

sql oracle-database plsql database-cursor
asked 2011-12-19T19:23:16.467
59
votes
4
answers

How do I remove the default value from a column in oracle?

sql oracle-database
asked 2011-12-12T22:04:55.163
33
votes
5
answers

DBVisualizer: set max rows in a select query

sql database oracle-database dbvisualizer
asked 2011-12-07T16:46:24.150
14
votes
3
answers

oracle SQL plus how to end command in SQL file?

oracle-database sqlplus
asked 2011-12-06T21:05:03.723
13
votes
2
answers

Oracle trigger to create an autonumber

oracle-database plsql triggers
asked 2011-11-30T17:31:21.743
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
9
votes
3
answers

How to use Oracle DMP files?

oracle-database database-backups
asked 2011-11-30T13:29:23.840
11
votes
4
answers

Listing more than 10 million records from Oracle With C#

c# performance oracle-database
asked 2011-11-30T09:02:28.133
8
votes
4
answers

How to track all queries submitted to Oracle DB from app server?

java sql oracle-database jdbc profiling
asked 2011-11-25T05:48:41.440
10
votes
5
answers

Simple Oracle variable SQL Assignment

oracle-database variables plsql toad
asked 2011-11-07T17:06:43.170
104
votes
15
answers

Where does Oracle SQL Developer store connections?

oracle-database oracle11g
asked 2011-10-31T14:03:35.933
26
votes
3
answers

Existing state of packages has been discarded

sql oracle-database stored-procedures error-handling plsql
asked 2011-10-27T18:15:12.257
40
votes
5
answers

Update rows in one table with data from another table based on one column in each being equal

sql oracle-database sql-update
asked 2011-10-27T15:52:51.780
112
votes
9
answers

Printing the value of a variable in SQL Developer

oracle-database plsql oracle-sqldeveloper
asked 2011-10-25T09:44:52.970
← Prev page 3 of 11 Next →