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

To avoid unexpected execution plan changes some people say that we must set DBMS_STATS estimate_percent should always be to 100. I would like to know if you agree with this ?