What is an Index ? How it is implemented in Oracle Database ?
- 4 Answers
- 10755 Views
- I also Faced
- E-Mail Answers
Answer Posted / nishi
An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to rename an existing table?
> 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?
How can we view last record added to a table?
How to create a server parameter file?
What is the dynamic sql in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is the difference between sharding and partitioning?
What is ASM (Automatic Storage Management) in Oracle?
How to export data with a field delimiter?
What is an oracle database table?
When do you get a .pll extension in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Explain joins in oracle?
How to define an anonymous procedure without variables?
What is the fastest query method to fetch data from the table?
