No Answer is Posted For this Question
Be the First to Post Answer
What is OCI. What are its uses?
What is sharded cluster?
What are the advantages of Views ?
How to use group functions in the select clause using oracle?
Differentiate between function and procedure in oracle.
Explain the use of full option in exp command.
What is a trigger and what are its types in oracle?
What is the dynamic sql in oracle?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
Explain cascading triggers.
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.
What is oracle sid?