Home » SQL & PL/SQL » SQL & PL/SQL » Help needed for writing a procedure (Oracle 10g)
Help needed for writing a procedure [message #377828] Thu, 25 December 2008 15:44 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: rowid
Next Topic: How to use Bulk Collect with dbms_sql.varchar2a in 10g
Goto Forum:
  


Current Time: Tue Dec 06 12:29:50 CST 2016

Total time taken to generate the page: 0.08316 seconds