Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

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



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com