SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Loading data into oracle

TJ_TayFeb 16 2012 — edited Feb 17 2012

Hi all

Please advise the following questions on how to load data into oracle database
I can make use of PL/SQL scripts to load data into the database using UTL_FILE,
To do so I have to create the datafile directory using a sys admin account, right?

Another way of loading data to database is to use LOAD INFILE, however for this I
have to have the unix access to execute?

Or what is a best way to load an excel of data to oracle database using a Oracle SQL developer?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2012

Added on Feb 16 2012

5 comments

316 views