Interested to Buy Any Domain ? << Click Here >> for more details...
How can we schedule the procedure to run automatically ?
- 3 Answers
- 10964 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 are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com
How to select random rows from a table?
what is online transaction processing (oltp)? : Sql dba
What are all types of user defined functions?
How to know the last executed procedure?
Can a foreign key be null?
Explain character-manipulation functions?
Explain unique key in sql.
When you have to use a default "rollback to" savepoint of plvlog?
Is mariadb nosql?
Can we insert in view in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
