Home » SQL & PL/SQL » SQL & PL/SQL » Reading records from a file
Reading records from a file [message #252953] Fri, 20 July 2007 22:30 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using Oracle 10g Release 2

Is it possible to read records one by one which are separated by white space characters.

As far as I know UTL_FILE reads records line by line and then we have to manually parse the line to access each word.
Re: Reading records from a file [message #252954 is a reply to message #252953] Fri, 20 July 2007 22:37 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
>Is it possible to read records one by one which are separated by white space characters.

NO

>As far as I know UTL_FILE reads records line by line and then we have to manually parse the line to access each word.

YES, that is correct.
Re: Reading records from a file [message #252961 is a reply to message #252953] Sat, 21 July 2007 00:25 Go to previous messageGo to next message
Art Trifonov
Messages: 11
Registered: June 2007
Location: Boston
Junior Member
Check out external tables.
Re: Reading records from a file [message #252962 is a reply to message #252953] Sat, 21 July 2007 00:27 Go to previous message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
Art,

Please post working example of how external tables simplifies read words separated by white space over using UTL_FILE.

[Updated on: Sat, 21 July 2007 00:28] by Moderator

Report message to a moderator

Previous Topic: selecting user defined records into ref cursor
Next Topic: refcursor not displaying the output
Goto Forum:
  


Current Time: Tue Dec 06 00:30:12 CST 2016

Total time taken to generate the page: 0.08554 seconds