Export and Import table from or to text file

Hello all,
Do you guys have any idea?
I want to export my table to a text file
and import a text file to a table
Thanks a lot!!!for export, you can use sqlplus and spool the result in a file or write pl/sql proc with utl_file to write a file

for importing a text file, use sql*loader utility

hope this help you

Originally posted by lawbenny
Hello all,

Do you guys have any idea?
I want to export my table to a text file
and import a text file to a table

Thanks a lot!!!sql