Skip to content
Advertisement

sql query to pl sql procedure

this is my requirement .i want fetch the record from one table and store it in another temporary table.i wrote as query.but dont know how to make it as procedure by declaring varibales and so.

Daily new customers data will gets inserted in table.I only want to fetch the customer data who signed attribute_value as ‘TOY_GIFT’ from last 10 to till today’s date. i want to run this as procedure for every 10 days.

Thanks in advance..

Advertisement

Answer

You need to create a proc to insert records, and set up a dbms job to execute it every 10 days.

Like, procedure :


DBMS Job:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement