I am troubleshooting a severe storage efficiency issue on a batch logging table in our Oracle 19c database on the below table Table DDL: CREATE TABLE APP_BATCH_LOGS ( BATCH_ID VARCHAR2(100 CHAR) NOT NULL, -- Partition Key PROCESS_ID VARCHAR2(100

This query: with T1 as ( select 'A4' from dual union select 'A3' from dual union select 'A100' from dual union select 'A20' from dual ) select * from t1; produces the normal sort: A100 A20 A3 A4 In recent Oracle versions ( 19 and later ) is there a

When querying a mounted database, an ORA-01219 occurs when querying anything besides instance views such as v$database. This is even the result when using a WITH clause that, itself, is an allowed query for a mounted database. For example: SQL> select status from v$instance; STAT...

I'm trying to create a database link using the CONNECT WITH clause that's mentioned in the documentation for CREATE DATABASE LINK so that I can use a database credential in the DDL statement. The doc I'm referring to is : https://docs.oracle.com/en/database/oracle/oracle-database...

<u></u>table has two rows select id,value from IIO_SYSTEM_PARAMETER; 200 1027/1029/1000 199 1027/1029/1000 when I ran the below query, it is giving 7 records, instead of 3 records query1: SELECT REGEXP_SUBSTR(VALUE, '[^/]+', 1, LEVEL) DEST FROM