Skip to main content

DUAL, Pagination and Top-N

Learn DUAL, Pagination and Top-N (Oracle Database Basics, Oracle) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Oracle needs a table in every SELECT, so it provides the one-row table DUAL. Row limiting changed in 12c.

More lessons in Oracle Database Basics