| |
|
What is the Dual table in Oracle?
Oracle databases contain a table with just one row, this is called 'Dual' table. It may be used
in scenarios where in a pseudocolumn like 'User' or 'Sysdate' is being queried.
It has a column called 'Dummy' with data type of varchar2(1) ... 1 being the size.
When this table is queried, it returns a column called 'Dummy'
with a value 'X'
select * from dual;
select sysdate from dual;
SQL Queries
SQL
Create Table
DDL, Create, Alter, Drop commands
DML, Select, Insert, Update, Delete
Create Database
ACID Rules
Dual Table
NULL
Join, Inner, Outer, Left, Right, Full, Cartesian, Natural, Equi
Table, View and a Synonym?
Execute
Function
Stored Procedure
Syntax Stored Proc
Stored Procedure Vs. Function
| |