Hi al,
i have to import data in to ORacle from text file using Oracle Forms 9i or above or 6i...
how can i do this? is any body have some idea plz help me its very urgent...
Thanx in advance.
Saquib
How to import data into an Oracle from text file.
-
- Posts: 7
- Joined: Wed Feb 21, 2007 1:05 am
- Location: Pakistan
-
- Posts: 4
- Joined: Wed Feb 14, 2007 10:38 am
- Location: India
Its.. simple..
Use TEXT_IO Package in Forms 6i
<b>Sample:</b>
-------------------------------------------
declare
in_file Text_IO.File_Type;
linebuf VARCHAR2(80);
begin
in_file := Text_IO.Fopen('salary.txt', 'r');
Text_IO.Get_Line(in_file,linebuf);
Message(linebuf);
end;
--------------------------------------------
Here its linebuf variable contains your data.
Use TEXT_IO Package in Forms 6i
<b>Sample:</b>
-------------------------------------------
declare
in_file Text_IO.File_Type;
linebuf VARCHAR2(80);
begin
in_file := Text_IO.Fopen('salary.txt', 'r');
Text_IO.Get_Line(in_file,linebuf);
Message(linebuf);
end;
--------------------------------------------
Here its linebuf variable contains your data.
Who is online
Users browsing this forum: No registered users and 0 guests