OraFAQ Forum: Forms » Load data from txt file and csv

Home » Developer & Programmer » Forms » Load data from txt file and csv

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Load data from txt file and csv [message #684505]

Thu, 17 June 2021 02:59

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Hello friends,

Kindly guide me how i can load data from txt or csv file in oracle forms.

abc.txt
s.no salary
1 4110
2 1000
3 5000

>PLEASE GUIDE ME HOW I CAN IMPORT DATA FROM ABC.TXT FILE.

Regards

Haider

Report message to a moderator

Re: Load data from txt file and csv [message #684508 is a reply to message #684505]

Fri, 18 June 2021 04:39

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

One option might be to use an external table. A form would then be used just like a nice GUI to do the job.

create a directory (Oracle object that points to a filesystem directory, which is usually located on a database server)
grant read (and write?) privilege(s) on it to use which will be using it
connected (in SQL*Plus or SQL Developer or any similar tool) as user who was granted privileges on a directory, create an external table
make sure it "works" (you can select from it)
create a stored procedure which will do the job - select from the external table and insert data into the target table
test the procedure
create a form whose data block is based on external table (so that you could see its contents)
put a button to the form and create a trigger which will call previously created stored procedure
test the form