Database Administration & Monitoring
SELECT FROM DUAL : Oracle Performance And Tuning
05.10.2021 by Oracle Team
The DUAL table is automatically created by Oracle and contains one column (DUMMY) and one row (x value). This table is often used by SQL developer in PL/SQL code (Package, Functions, Trigger) to initialize variables storing technical information such as(…)