conditional where with subquery...

dotConnect: CROSS APPLY is not supported by Oracle Database 11g...

does an update statement in oracle hold a lock even if no rows were updated...

Calculate data based on previous values of rows...

ORA-00932: inconsistent datatypes: expected DATE got NUMBER...

Difference between Schema and Owner of Table...

java.sql.SQLException: ORA-01501: CREATE DATABASE failed ORA-01100: database already mounted...

dynamic sampled query in oracle db trace...

Rows of table variables and columns of counts, min and max?...

Oracle query to return each week and month including mid week month changes...

How to retrieve body of "verify_function" Oracle 11g...

Oracle DBMS_SCHEDULER.DROP_JOB fails to drop a job...

SQL*Plus HTML Markup: Preventing Raw HTML Tags from Appearing in Output File...

ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client...

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1...

literal does not match format string oracle 11g...

Oracle - Convert UTC Date to Local Date Time US Format...

ORA-00947 Not enough values while declaring type globally...

Oracle Partition by ID and subpartition by DATE with interval...

link dba_fga_audit_trail with v$session or history of session...

How to insert a column in a specific position in oracle without dropping and recreating the table?...

Link Oracle 11g and Oracle 19c database?...

Sum a record with its previous not-null ordered by timestamp...

How to use Oracle's LISTAGG function with a unique filter?...

Echo sqlplus command without using prompts or scripts...

Oracle find tablename given an index name...

Oracle SQL Developer - How to Display Percents using Color (Not Numbers)...

ORA-22285: non-existent directory or file for FILEOPEN operation...

Cannot stop/drop job in DBMS_SCHEDULER...

Oracle ORDERED hint cost vs speed...