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

A tuning book says window functions and the 12c row limiting clause often fail to trigger Top‑N Stopkey even with a perfect index, so I tried to reproduce that behavior and saw the same thing—ROWNUM uses stopkey, but ROW_NUMBER() and FETCH FIRST don’t. Here’s the test case and th...