How can we schedule the procedure to run automatically ?
- 3 Answers
- 10074 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahesh
By using dbms_job (buitin package upto oracle 9i)
and using dbms_scheduler (oracle 10G onwrds)
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / swapna
We Can Schedule The Procedure Run Automatically By Using
Packages.
| Is This Answer Correct ? | 6 Yes | 5 No |
What is #table in sql?
Advantages and disadvantages of stored procedure?
What are the qualities of 2nf?
What is minus?
what is transaction? : Sql dba
in procedure how to return a value
what are the types of join and explain each? : Sql dba
What are the attributes of SQL*PLUS ?
2 Answers Dream Careers, Oracle,
What is the use of a view in sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
Types of joins ?
Why should I use postgresql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
