Home » SQL & PL/SQL » SQL & PL/SQL » urgent
urgent [message #21013] Fri, 05 July 2002 23:49 Go to next message
SHARMA POLPE
Messages: 5
Registered: July 2002
Junior Member
hi
i am trying to export data from a table which the output file should be in .txt (not any .dmp file)

the same may be appended back in table
exp. load data

Report message to a moderator

Re: urgent [message #21014 is a reply to message #21013] Sat, 06 July 2002 01:37 Go to previous messageGo to next message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
HAI,

YOU CAN USE THE FOLLOWING COMMAND LIKE

SQL>SPOOL C:SS.TXT
SQL>SPOOL ON
SQL>SELECT * FROM EMP;
SQL>SPOOL OFF

THAT'S ALL.

K.SREENIVASAN

Report message to a moderator

Re: urgent [message #21051 is a reply to message #21013] Tue, 09 July 2002 07:05 Go to previous message
AYSEGUL
Messages: 4
Registered: July 2002
Junior Member
SQL>SPOOL C:SS.TXT

SQL>SELECT * FROM EMP;
SQL>SPOOL OFF

THAT'S ALL.

Report message to a moderator

Previous Topic: help with 3 tables
Next Topic: calling stored proc in a package
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 14:47:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.