SQL* Plus CLI  «Prev 

Format for Oracle Skip Clause

Format for skip clause in Oracle
  1. BREAK: The SKIP clause is part of the BREAK command.
  2. ON column_name: This tells SQL*Plus which column you are working with. The subsequent SKIP clause applies to this column.
  3. SKIP: The SKIP keyword introduces the skip clause.
  4. PAGE: If you use SKIP PAGE, the result is a page-break whenever the column's value changes.
  5. line_count: If you do not want a page-break, then specify a number here. When the column value changes, SQL*Plus will advance the specified number of lines.
  6. The entire line containing the second "ON" clause: You may list as many columns as you like in the BREAK command.