Help needed for writing a procedure [message #377828] |
Thu, 25 December 2008 15:44  |
surbalu
Messages: 1 Registered: December 2008
|
Junior Member |
|
|
Hi I have scenario like
The below are records in one single table
schemaname logtablename frequency date
abc abc.logtable hourly 12/25/2008:22:10:00
xyz xyz.logtable2 daily 12/25/2008:11:10:00
GHD ghd.logtable3 monthly 12/25/2008:12:10:00
Hourly :
For hourly , I have to go to particular schema and go to paritcular log table get the latest record(using max(startrundate)) .The log record should be generated based on frequency and date on the table
example :
ABC schema --- go to abc.logtable and I should run on every hour and 12/25/2008:22:10:00 only particualr time ( means 22:10:00) to get the latest record from log table and genereate html format.
Daily:
For daily , I have to go to particular schema and go to paritcular log table get the latest record(using max(startrundate)) .The log record should be generated based on frequency and date on the table
Example:
XYZ schema ,go to xyz.logtabl3 and I should run on daily at particular time (12/25/2008:11:10:00) at 11:10am to get the latest record from log table and genrated html file .
Please give me some example on this.
|
|
|
Re: Help needed for writing a procedure [message #377893 is a reply to message #377828] |
Fri, 26 December 2008 02:16  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Your table is unreadable.
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).
Post a Test case: create table and insert statements along with the result you want with these data.
You have to also specify what should happen when you insert, update or delete a new row, what is the granularity/quantum of your datetime, what is the maximum delay between expected time and real execution time...
Regards
Michel
|
|
|