|
Blue Forest http://www.lslnet.com at 3:18 p.m. on August 26, 2006
[Pl/sql QUE -- on the role of system variables! !
In pl/sql, some of the system variables to control output file format, as follows :
[code]
400 SET LINES
SET PAGES 0
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS';
OFF SET TRIMSPOOL
HEADING OFF SET
OFF SET FEEDBACK
OFF SET VERIFY
SERVEROUTPUT ON SET
TERMOUT ON SET
[/code]
Please help me explain in detail the role of variables that are not listed above, I still have some way to go, pagesize, linesize, etc., and other factors help explain its role?
|
Only used three :
HEADING OFF/ON : control the outcome of the inquiry whether the name field
FEEDBACK : OFF/ON control whether the findings show that the implementation language
SERVEROUTPUT OFF/ON : whether the findings show that the output control DBMS_OUTPUT package |
| |