What are the different approaches used by Optimizer in
choosing an execution plan ?
Answers were Sorted based on User's Feedback
How to use "in out" parameter properly?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to see the table columns used in an index?
What is a connect identifier?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Can a Tablespace hold objects from different Schemes ?
Can you create a synonym without having a table?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What are privileges and grants?
Explain the dml?