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!

Pl/Sql code for insert text file data into oracle database

904328Dec 8 2011 — edited Jul 11 2012

Hi

Pl/Sql code for insert text file (containing comma separated values) into table in oracle 11g database.

Example:- file containing comma separated values (csv) are like this 123,cdf,ghi
234,rty,xyz
567,tyu,iop

The code should be written only in pl/sql.

And and should not use sql loader.

Please can anyone help me.

Thanking you

Regards
Sony

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 8 2012

Added on Dec 8 2011

#excel, #insert

21 comments

11,494 views