Assuming today is Monday, how would you use the DBMS_JOB
package to schedule the execution of a given procedure owned
by SCOTT to start Wednesday at 9AM and to run subsequently
every other day at 2AM.
No Answer is Posted For this Question
Be the First to Post Answer
What are the roles of dba?
How many types of tables are there in oracle?
Can objects of the same schema reside in different tablespace?
What is meant by an index?
How to empty your oracle recycle bin?
What is set operator oracle?
What is an oracle function?
how to retrive xml data for using sql query?
How to save query output to a local file?
Differentiate between TRUNCATE and DELETE?
Can we store pictures in the database and if so, how it can be done?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.