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

----------------------------------------------------------------------
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

----------------------------------------------------------------------
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

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


Current Time: Mon Oct 26 02:55:55 CDT 2020