What is the purpose of a cluster?
Answer / nishi
Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a CLUSTER. A CLUSTER provides a means for storing data from different tables together for faster retrieval than if the table placement were left to the RDBMS.
| Is This Answer Correct ? | 0 Yes | 0 No |
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
How to retrieve the count of updated rows?
Can a formula column referred to columns in higher group ?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
How to define an external table with a text file?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
how can we store any pdf file in oracle
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is the Tune Query
What is the simplest tool to run commands on oracle servers?
State and explain the different types of data models?