oracle use spool to write to text
来源:互联网 发布:php implode 爱好 编辑:程序博客网 时间:2024/05/16 09:25
最近用spool 导数据.
set linesize 9000
set serveroutput off;
set pagesize 10000;
set trimspool on;
set scan off;
set define off;
set echo on;
spool c:\TABLE.sql
SELECT 'SELECT '''||u.table_name||''', COUNT(1) AS RECORD_COUNT FROM '||u.table_name||';'
FROM USER_TABLES u
-- where rownum <5
ORDER BY u.TABLE_NAME;
set scan on;
set define on;
spool out;
linesize设置成多大最后导出来的记录有些还是给截掉了。
网上查了一下也没有什么好办法的,最后用控制台来导出,OK!!!!
- oracle use spool to write to text
- write to text file DEMO
- Use the SQL Server CLR to Read and Write Text Files
- Use Jython to Write Ant Tasks
- Use Jython to Write Ant Tasks
- Use Haskell ByteString to Read/Write File
- Use Dom4J to Write XML file
- Use Jdom to Write XML file
- use properties write to config.properties files
- begin to write technical text blog
- How to use whiptail to write interactive shell scripts
- How to use boost::property_tree to load and write JSON
- Preparing to Use LZO-Compressed Text Files
- Use Shell to Insert Oracle
- How to use Oracle Hint
- Oracle To Mysql (Use Goldengate)
- to write ...
- to write ...
- .net 图片上传
- java异常说明
- c# 抓取网页内容
- 提问前我们该做什么?
- 形象理解卷积(卷积运算为何要翻转)
- oracle use spool to write to text
- ATOM全局原子
- 如果myeclipse不显示svn的版本号怎么办
- 杭电水题--1197 Specialized Four-Digit Numbers
- 继承、多态、抽象类、接口
- objective-c 中随机数的用法 (3种:arc4random() 、random()、CCRANDOM_0_1() )
- -bash: /home/oracle: is a directory
- 对称子字符串最大长度
- 时间来不及 随便写点 Map的两种取值(键值 和 值)方法 但是取出的值是无序的怎么办?