I am implementing a 4-Schema SmartDB architecture for an Oracle APEX project to strictly enforce the principle of least privilege. My schemas are: DATA_LAYER (Tables), LOGIC_LAYER (Private Logic), API_LAYER (Public Interface), and APEX_UI_LAYER (Parsing Schema). I am currently de...

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

<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

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

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...