Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Save Query Output to a Local File
How To Save Query Output to a Local File? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool
✍: FYIcenter.com
Normally, when you run a SELECT statement in SQL*Plus, the output will be displayed on your screen. If you want the output to be saved to local file, you can use the "SPOOL fileName" command to specify a local file and start the spooling feature. When you are done with your SELECT statement, you need to close the spool file with the "SPOOL OFF" command. The following tutorial exercise gives you a good example:
SQL> connect HR/retneciyf SQL> SET HEADING OFF SQL> SET FEEDBACK OFF SQL> SET LINESIZE 1000 SQL> SPOOL \temp\employees.lst SQL> SELECT * FROM EMPLOYEES; ...... SQL> SPOOL OFF
You should get all records in employees.lst with fixed length fields.
2007-04-29, 5991👍, 0💬
Popular Posts:
What metrics will you look at in order to see the project is moving successfully? Most metric sets d...
If cookies are not enabled at browser end does form Authentication work? No, it does not work.
.NET INTERVIEW QUESTIONS - Can we use events with threading ? Yes, you can use events with thread; t...
What are the different storage classes in C? C has three types of storage: automatic, static and all...
Describe different elements in Static Chart diagrams ? Package: - It logically groups element of a U...