How many different types of indexes we have in oracle?
Answer Posted / srinivasarao
total indexes are in oracle is 5
1.b tree
2.bitmap
3.function_based
4.domain
5.ascending or descending
Is This Answer Correct ? | 27 Yes | 17 No |
Post New Answer View All Answers
What exactly do quotation marks around the table name do?
What is oracle instant client?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is raw datatype?
What are the uses of linked server and explain it in detail?
State and explain about oracle instance?
How to define an oracle sub procedure?
Is oracle an open source?
What is private procedure oracle?
What are internal user account in oracle?
What are the different windows events activated at runtime ?
query optmization techniques and quwry analyser+projects+ppts
What is hash cluster in oracle?
What language does oracle use?
How to call a sub procedure?