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

Before understand question mind I have one table with 3 columns one is id second is description and third is sql query, i created one Apex page with two region one is static region and one is Interactive Report Region. In Static region i have one select list for user and in Inter...

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

Hi all, I have a problem with liveSQL. I can't create a sharable link. Even with FreeSQL, can't do so. Appreciate any help. Thnks

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