logo
Redian新闻
>未名空间
>Database - 数据库
>
a simple question on Oracle
avatar
a simple question on Oracle# Database - 数据库
e*r
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
avatar
c*d
2 楼
你是问如何格式化输出吗
set linesize 120
set pagesize 500
format [colname] a20
avatar
j*a
3 楼
format and use spool to save the output.
avatar
s*c
4 楼
sqlplus can redirect the output to a file: spool?
avatar
j*a
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?
相关阅读
ODBC API header file?Managment server in Oracle8iIs there a download site of ERwin?how to delete log怎样实现WWW Client的安全登录？who has registration code for toad?access Vs. SQLOracle Default passwd for SYS, SYSTEM is not valihow to roll backRe: 求救!!! 一个oracle的问题! 在procedure中所涉及的表名可以用变量从参数中传入吗如何从一个表中删除在另一个表中存在的记录Re: how to separate the table ---PSSQL Server restore(transferred from other DB) error... HELP!傻问题. 瘟98里面sql server的服务器端可以运行吗?怎样用ASP向Foxpro里插入Date型数据?How to change INTERNAL's password in Oracle8i?讨论:在SELECT中限制TOP N条纪录ACCESS中的图片在网页中显示问题 ORACLE 底下有什么好的加密包？Re: 蒙古国土荒漠化严重
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。