Interested to Buy Any Domain ? << Click Here >> for more details...
How can we schedule the procedure to run automatically ?
- 3 Answers
- 10908 Views
- I also Faced
- E-Mail Answers
Answer Posted / nakul.v
We can Schedule a Stored Procedure to run automatically
once we attach the Procedure to a Package and use the
Built – In DBMS_JOB Package.
DBMS_JOB.SUBMIT & DBMS_JOB.RUN will help us to Schedule a
Stored Procedure
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is difference between primary and secondary key?
What is a field in a database?
Which certification is best for sql?
What is a recursive stored procedure?
What is nvarchar in sql?
What is sql key?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What are the two characteristics of a primary key?
How many row comparison operators are used while working with a subquery?
Explain sql data types?
what is self-join? : Sql dba
What is a nested table in word?
How do temporal tables work?
Why do we create views in sql?
What is db journal file?
