DUAL Table and Sequences

DUAL Table

Special one-row table for pseudo queries.

SELECT SYSDATE FROM dual;

SEQUENCES

CREATE SEQUENCE emp_seq START WITH 100 INCREMENT BY 1;
SELECT emp_seq.NEXTVAL FROM dual;