Answer Posted / a.praveen kumar
It is a schema object to improve the performance of select statement which is using multiple database tables with standard join condition.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to write a query with a left outer join in oracle?
What is Library Cache in Oracle?
What are the various constraints used in oracle?
How to create a new table in oracle?
How will you differentiate between varchar & varchar2?
What is oracle update statement with inner join ?
List out the types of joins.
What is oracle server autotrace in oracle?
How to delete an existing row from a table in oracle?
How do we get field detail of a table?
What is a tns service name?
What are the uses of synonyms?
Explain the use of control file?
What are the parameters that we can pass through a stored procedure?
Explain enable novalidate constraint.