set verify and set define

set verify [SQL*PluS]
		set verify on set verify off If verify is on, SQL*Plus prints two lines for each substituted variable (see set define). Storing settings across sessions

[@more@]

set verify [SQL*PluS]
		set verify on set verify off If verify is on, SQL*Plus prints two lines for each substituted variable (see set define). Storing settings across sessions Settings (such as verify) can be stored accross sessions with the glogin.sql and/or login.sql file.

set define [SQL*Plus]
		set define on set define off set define x set define x set define x specifies the prefix-character for substitution variables. The default is the ampersand (&). set define + * from where object_name '%+object_name%'; set define on Turns on substitution variables. set define on select '&hello' from ; If define is set to on and SQL*Plus finds the current substituion prefix, it asks for a string to be entered. In the following example, I entered: this string was entered Enter value for hello: this string was entered old 1: select '&hello' from dual new 1: select 'this string was entered' from dual 'THISSTRINGWASENTERED' ----------------------- this string was entered It might be annoying to see the following lines printed by SQL*Plus: old 1: select '&hello' from dual new 1: select 'this string was entered' from dual This behavior can be turned off by setting verify off. set define off Turns off substitution variables. set define off select '&hello' from ; '&HELL ------ &hello

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/330796/viewspace-891307/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/330796/viewspace-891307/