Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • Last Modified:

Looping through all the lines in a file.

In oracle plsql, how to loop through each and every line in a flat file.

for eg, in and each every line, I need to check the position of a particuar word and store it in a variable.

how to do this?
0
sakthikumar
Asked:
sakthikumar
1 Solution
 
RindbaekCommented:
Zea zodiac has a good answer here to reading the file line by line line just do what you need to do instead of the   "dbms_output.put_line(l_text);"
http://www.experts-exchange.com/Database/Oracle/Q_21081949.html

If the file is a text file with some sort of a seperator  you could see it as an external table instead.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/et_concepts.htm
0
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Can you please provide the sample of your flat file and desired output?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now