When can Hash Cluster used ?
Answer / orawhiz
Hash clusters are better choice when a table is often
queried with equality queries. For such queries the
specified cluster key value is hashed. The resulting hash
key value points directly to the area on disk that stores
the specified rows
| Is This Answer Correct ? | 1 Yes | 0 No |
What is Partitions in Table ?
what is the difference between no rows returned and null returned?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
Explain the use of tables option in exp command.
how to we delete a row using varray
how to hide the stored procedure inside a package
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How to export data with a field delimiter?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
What is an oracle transaction?
Write a trigger example in oracle?