Create a report from a log in oracle reports

Hi All,
I am working with oracle reports 6i. I have to create a report who source is log. I have created report using table but never with logs. Is this possible can we create report in oracle reports 6i from a log. Please help Urgent.

Thanks
Sweetysmile

sweetysmileAsked:
Who is Participating?
 
Stephen LappinSenior TechnologistCommented:
Here is a step-by-step guide:

http://www.dbazine.com/oracle/or-articles/moore1
0
 
Stephen LappinSenior TechnologistCommented:
Can you create an external table for the log, and report against that?
0
 
sweetysmileAuthor Commented:
I am not sure how do that i have never worked on external table
can u help me how to go about that
it will be very helpful

thanks
deepthi
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
sweetysmileAuthor Commented:
Hi Lappins

Thanks will go thu the article and get back.

Sweetysmile
0
 
sweetysmileAuthor Commented:
Hi Lappins

their another point their alot  junk data  in the txt file before the actually data comes
how do i filter this unneccessary info

Thanks
Deepthi
0
 
Stephen LappinSenior TechnologistCommented:
You can skip 'header' records that appear before the data you are interested in. Have a look at this SQL*Loader FAQ:

http://orafaq.com/faqloadr.htm#SKIP
0
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.