Home » SQL & PL/SQL » SQL & PL/SQL » *** .txt file to Table data transfer ***
*** .txt file to Table data transfer *** [message #36786] Thu, 20 December 2001 10:34 Go to next message
Robin
Messages: 73
Registered: October 2001
Member
Experts,
I can send result of a query (data) to a .list file by spool comand, But cannot import that data into a table from .list file. Pls help me with script pls.

Thanks
Robin

----------------------------------------------------------------------

Report message to a moderator

Re: *** .txt file to Table data transfer *** [message #36790 is a reply to message #36786] Thu, 20 December 2001 14:07 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use sqlloader

----------------------------------------------------------------------

Report message to a moderator

Suresh Vemulapalli, Thank u [message #36812 is a reply to message #36790] Sun, 23 December 2001 06:20 Go to previous message
Robin
Messages: 73
Registered: October 2001
Member
Sir,
Thank u for ur advice, I will try then inform u
Thank u again, Sir.

Robin

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Re: Reading Text File to Oracle Table by PL/SQL Code
Next Topic: * Running Stored procedure *
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 15:43:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.