| SET coomand [message #74186] |
Fri, 01 October 2004 05:14  |
snehal
Messages: 8
Registered: October 2000
|
Junior Member |
|
|
hello,
I have a huge flat file . I am giving following command at sql prompt.
select * from table
I want to set the display off so it does not show all the records on sql prompt but it will select all records and genrate log file .
Which SETcommand will do this job ?
Many thanks in advance .
|
|
|
|
| Re: SET coomand [message #74189 is a reply to message #74186] |
Fri, 01 October 2004 07:05  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
use set term off.
spool the output.
SET TERM OFF may not work in interactive mode.
bash-2.03$ sqlplus -s mag/mag @dospool.sql
bash-2.03$ cat dospool.sql
spool somelist.lst
set term off;
select * from cat;
spool off
exit
bash-2.03$ cat somelist.lst
TABLE_NAME TABLE_TYPE
------------------------------ -----------
A TABLE
DEPT TABLE
EMP TABLE
MEMBER TABLE
MEMBERSEQ SEQUENCE
PLAN_TABLE TABLE
SAMPLE TABLE
T VIEW
TAB_TABLE TABLE
T_BASE VIEW
T_BPKC VIEW
T_CONF VIEW
T_DIFF VIEW
T_HIST VIEW
T_LOCK VIEW
T_LT TABLE
T_MW VIEW
T_PKC VIEW
T_PKD VIEW
lowercase TABLE
20 rows selected.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
