- 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
SERVEROUTPUT
Synopsis
Oracle7:
SERVEROUT[PUT] {OFF | ON} [SIZE n]Oracle8:.
SERVEROUT[PUT] {OFF | ON} [SIZE n]
[FOR[MAT] {WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED]}]Controls whether to display the output (generated by the DBMS_OUTPUT.PUT_LINE procedure) of stored procedures or PL/SQL blocks in SQL*Plus.
- OFF
Suppresses the output of DBMS_OUTPUT.PUT_LINE.
- ON
Displays the output.
- SIZE
Sets the number of bytes of the output that can be buffered within the server. The default for n is 2000, and n must be between 2000 and 1,000,000.
- FOR[MAT] WRA[PPED[
Specifies that SQL*Plus will wrap output; line breaks will occur in the middle of words, if necessary.
- FOR[MAT] WOR[D_WRAPPED]
Specifies that SQL*Plus will word-wrap output; line breaks will only occur at line boundaries.
- FOR[MAT] TRU[NCATED]
Specifies that SQL*Plus will not wrap output, but will truncate it at the end of the line.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.