How to load a talbe in SQL?

Dear dBforums memebers:

I want to know how to load a table in SQL*Plus environment.

I created a table called author(author_name char(30) ). Instead of using single INSERT statement. I want to load table with a datafile, or a script file.

Could someone tell me the procedure which will load a table using data file or a script file. My friend told me that SQL*Loader may do the job, but i couldn't find information on oracle website regrading this matter.

Can anyone can give me some suggestions. I appreciate your help:)

if possible, please show me a a detailed example, or web sources.

sjgrad03
12-20-03Your friend was correct, SQL*Loader is the right tool. See documentation at http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/part2.htm#436160

In order to access the documentation, you must login to the Oracle Technet web site. If you don't login, the URL will hang.