Why do you use stored procedures and state some of its disadvantages?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the different normalization forms?
How to delete a column in an existing table in oracle?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Explain the function of optimizer in oracle?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
Which are the five query types available in oracle?
What is a Redo Log ?
List out the types of joins.
Differentiate between pre-select and pre-query?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?