How to create a stored program unit?

Question Posted / papeesh kumar

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle General Interview Questions

Can we convert a date to char in oracle and if so, what would be the syntax?

What is columnar storage what is the advantage?

how to get last monday of a month?

What is the usage of control file in oracle?

how do u know the total no of rows in a table?

What would you use to improve performance on an insert statement that places millions of rows into that table?

What are the parameters that we can pass through a stored procedure?

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

Difference between sub query and nested query ?

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

what is analyze command ? what kind of statistics does it generate?

What is a data dictionary and how can it be created?

For more Oracle General Interview Questions Click Here