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?
Who is Participating?
RindbaekConnect With a Mentor Commented:
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);"

If the file is a text file with some sort of a seperator  you could see it as an external table instead.
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Can you please provide the sample of your flat file and desired output?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.