This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / HI, I have a question about Oracle. Maybe it's easy to everyone here.
How can I export data in a table in Oracle to a text file? what is the easiest way to do it?
Urgent!
Thanks first.
-sindy11(独上西楼);
2004-9-20
(#1894278@0)
-
spool
-wander2001(猫行天下);
2004-9-20
(#1894296@0)
-
I want one record one line in the text file. But I have 82 columns and I tried spool , the result is one record break up to several lines in the text file.
-sindy11(独上西楼);
2004-9-20
(#1894308@0)
-
set linesize xxxxxx and set pagesize 0
-handd(大熊猫®);
2004-9-21
(#1895949@0)
-
Option2: Toad
-yehongwei(天拖南);
2004-9-20
(#1894522@0)