e******r
发帖数: 220 | 1 If after running sql statements, there are many lines of records
returned such that it couldn't display on many screens.
What could we do to make it easier to study those records by eyes?
thanks
|
c*****d
发帖数: 6045 | 2 你是问如何格式化输出吗
set linesize 120
set pagesize 500
format [colname] a20 |
j***a
发帖数: 10844 | 3 format and use spool to save the output. |
s*****c
发帖数: 24 | 4 sqlplus can redirect the output to a file: spool? |
j***a
发帖数: 10844 | 5
Why not?
Try this in sqlplus:
spool c:\sqloutput.txt
select * from emp;
spool off
【在 s*****c 的大作中提到】
: sqlplus can redirect the output to a file: spool?
|
