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: 460
  • Last Modified:

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

0
sweetysmile
Asked:
sweetysmile
  • 3
  • 3
1 Solution
 
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
 
Stephen LappinSenior TechnologistCommented:
Here is a step-by-step guide:

http://www.dbazine.com/oracle/or-articles/moore1
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Technology Partners: 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!

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