Home » SQL & PL/SQL » SQL & PL/SQL » Import/Export data from/to text file
Import/Export data from/to text file [message #214830] Thu, 18 January 2007 04:17 Go to next message
premchellam
Messages: 6
Registered: January 2007
Junior Member
How to import and export the data from the text file into table and vise versa? Anybody have the query for this?

Thanks in advance,
Prem
Re: Import/Export data from/to text file [message #214834 is a reply to message #214830] Thu, 18 January 2007 04:23 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Look at SQL*Loader and sql*plus spool in the documentation.
Re: Import/Export data from/to text file [message #214866 is a reply to message #214830] Thu, 18 January 2007 05:21 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Depending on your requirements, you may also want to consider External Tables and UTL_FILE.
Previous Topic: FOR ALL ?
Next Topic: Question about SNAPSHOT
Goto Forum:
  


Current Time: Sun Aug 20 20:01:46 CDT 2017

Total time taken to generate the page: 0.09645 seconds