ORACLE 9i PLSQL Optimizer causing some performance issues with constant VARIABLES...

How to analyse the oracle statspack which is in the html format?...

Extract only alphabetic characters from VARCHAR column...

how to overcome CLOB run out of space - ORA-06502: PL/SQL: numeric or value error...

getting oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException error...

remove rows with some duplicate column value...

Keyword 'Values' absent Oracle 9i...

complete a table with data from an other one...

Table,View Or Sequence reference 'SEQUENCE.NEXTVAL' not allowed in this context...

ORA-00928 selecting from view over DB link, but works locally...

Finding the datatype of a cursor or table column in a block...

Updating row based on values in previous rows...

Sort key too long error in oracle sql 9i...

Print the number of COMMITTED lines or/and commands executed...

Is there a maximum number of connections allowed on Oracle9i DB?...

Generating Random String in PL/SQL(oracle 9i) with restricted Letters...

How can I export a table's one month data in Oracle?...

Convert multiple rows into 1 column without pivot in oracle...

Rows with null value in a column don't show up when compared with a string...

How to select sub string from a column of type VARCHAR2?...

Insert select continue with error...

Transpose the resulted rows in Oracle 9i...

Extract BLOB data from Oracle Database and convert to original file...

Add sub partition on another column in oracle...

In oracle SQL, how would you obtain the timestamp representing the start of the week?...

Single SQL SELECT Returning multiple rows from one table row...

ORA-918 for ambiguous column in Oracle 9.0.2.8 but not 9.0.1?...

How to improve the efficiency of below query?...

How do you extract number of rows in Count(*), and send to a variable. (Pl/SQL)...

Group rows Keeping the Order of values...