Give the constructs of a package, function or a procedure.
No Answer is Posted For this Question
Be the First to Post Answer
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to convert numbers to characters in oracle?
how to get count of tables in particular database in Oracle?
How to invoke the data pump import utility?
What is a Redo Log ?
How to load data from external tables to regular tables?
State and explain the different types of data models?
How to do clean up if create database failed?
How to list all indexes in your schema?
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.
when loggined as SYSTEM,how to display all the users of database using sql query?