- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
Name
BREAK
Synopsis
BRE[AK] [ONcolumn|expression| ROW | REPORT [action[action]]]...
Specifies where and how to change the formatting of a report.
- column
Causes the action to take place whenever the value of the specified column changes.
- expression
Causes the action to take place whenever the value of the expression changes.
- ROW
Causes the action to take place whenever SQL*Plus returns a row.
- REPORT
Causes the corresponding COMPUTE command to be executed at the end of the report.
- action
Can be one or more of the following:
- SKI[P] n
Skips n lines before printing the row where the break occurred.
- SKI[P] PAGE
Skips the necessary number of lines to advance to a new page. If SET NEWPAGE is specified, prints a formfeed.
- NODUP[LICATES]
Causes blanks to be printed (rather than the value of the break column) when the value is the same as the value in the preceding row.
- DUP[LICATES]
Causes the value of the break column to be printed for every row.
- BREAK
Lists all current BREAK definitions.
-
No Comment