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 turn on or off recycle bin for the instance?
How to create a table in a specific tablespace?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
what are steps for interface? where is exchange rate defined in which table?
What privilege is needed for a user to connect to oracle server?
Explain the use of record option in exp command.
Is it possible to insert comments into sql statements return in the data model editor ?
Explain the use of compress option in exp command.
State and explain about oracle instance?
How to assign a tablespace to a users in oracle?
Explain the use of tables option in exp command.
What are the oracle built-in data types?
Explain parameter file in oracle.
Can a formula column be obtained through a select statement ?
What is set verify off in oracle?