?
Solved

Looping through all the lines in a file.

Posted on 2011-03-15
2
Medium Priority
?
367 Views
Last Modified: 2012-06-27
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
Comment
Question by:sakthikumar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
Rindbaek earned 2000 total points
ID: 35137218
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
 
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 35141593
Can you please provide the sample of your flat file and desired output?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question