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 |
List out the types of joins.
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to use values from other tables in update statements using oracle?
What do you mean by group by clause?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to rename an existing table?
How to retrieve data from an cursor to a record?
How do I start tns listener?
How to handle a single quote in oracle sql?
types of indexes and the rationale behind choosing a particular index for a situation.
How are extents allocated to a segment?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c