Top "Oracle" questions

Re-order columns of table in Oracle

I have a table with 50+ columns and I need to swap the order of the first two columns. What is …

sql oracle rename

Using an Alias in a WHERE clause

I have a query which is meant to show me any rows in table A which have not been updated …

sql oracle alias decode ora-00904

What does it mean when the size of a VARCHAR2 in Oracle is declared as 1 byte?

I know that I can declare a varchar2 using the number of the characters that it should be able to …

sql oracle varchar sqldatatypes

How can you tell if a value is not numeric in Oracle?

I have the following code that returns an error message if my value is invalid. I would like to give …

sql oracle plsql isnumeric

Oracle "ORA-01008: not all variables bound" Error w/ Parameters

This is the first time I've dealt with Oracle, and I'm having a hard time understanding why I'm receiving this …

sql oracle plsql oracle10g

Oracle JDBC intermittent Connection Issue

I am experiencing a very strange problem This is a very simple use of JDBC connecting to an Oracle database …

java oracle jdbc

SELECT data from another schema in oracle

I want to execute a query that selects data from a different schema than the one specified in the DB …

sql oracle cx-oracle

ORA-00060: deadlock detected while waiting for resource

I have a series of scripts running in parallel as a nohup on an AIX server hosting oracle 10g. These …

database oracle unix plsql aix

Error : ORA-01704: string literal too long

While I try to set the value of over 4000 characters on a field that has data type CLOB, it gives …

oracle codeigniter clob nclob

Java: How to insert CLOB into oracle database

I need to write an XML file content into oracle database where the column is of CLOB datatype. How will …

java oracle insert clob