What is Index Cluster ?
Answers were Sorted based on User's Feedback
Answer / swapna
we can create Index on clusters.
syntax: create index<i_name> on cluster(cluster_name);
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nishi
A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages
Is This Answer Correct ? | 0 Yes | 0 No |
which language is used to develop the oracle........?
Differentiate between translate and replace?
What are the trigger associated with image items ?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
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
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
Give syntax for SQL and ORACLE joins.
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is an Index ?
if you ctreate table identity
Does oracle database need java?
what is the syntax of update command?