select empty table sql code example

Example 1: sql empty table

-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With possible rollback
DELETE FROM my_table;
COMMIT;  -- or ROLLBACK;

Example 2: sql empty select

-- NOTE: this is for SQL-Oracle specifically

-- syntax:
SELECT <testing_result> 
FROM DUAL;

-- example:
SELECT 1+2, 2+3, 3+4 
FROM DUAL;

-- OUTPUT: 3,5,7