> DUAL Table - Quick Note
DUAL is a special dummy table in Oracle with exactly one row and one column. Used when you want to run a SELECT that doesn't need a real table.
SELECT 2 2 FROM dual; -- Output: 4
SELECT SYSDATE FROM dual; -- Output: today's date
SELECT Q'[Raj's name]' FROM dual; -- Output: Raj's name
• Think of DUAL as Oracle's calculator table - use it whenever you want to test expressions or functions without needing a real table
#OracleSQL#Aliases#DISTINCT#Concatenation#QOperator#DESCRIBE#DUALTable#Comments#LearnSQL#Day11#100DaysOfCode#TechTwitter
There R symbolisms of knots, tie, can not, tie knot, mend or mending, sew-ing - sew-ers..strings, rings, & “things”. We have to connect the right channels or lines though - plugging in or “linking” (chains or rings...or breaking, freeing, or unionizing - which “switch”QOperator?)