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
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
How to list all user accounts in oracle?
List the various oracle database objects?
what is the bitmap index?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
How to delete all rows a table in oracle?
Do View contain Data ?
Explain what are the type of synonyms?
What are the varoius components of physical database structure of oracle database?
Whether any commands are used for months calculation? If so, what are they?
How do I spool in oracle?