Friday, March 16, 2007
Defining Variables in sqlplus
The following is an example of how variables can be declared in sqlplus sessions.
var col1 char(2000)
var col2 char(2000)
exec ms_prc(123,123,:col1,:col2);
set pagesize 0
set linesize 10000
spool on
print col1
print col2
spool off
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)