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: Insertion of long column into clob column
Next Topic: how to skip duplicate records in a procedure from processing
Goto Forum:
  


Current Time: Sat Dec 03 07:56:30 CST 2016

Total time taken to generate the page: 0.21118 seconds