Answer Posted / rudrab123

Answer 1 is not he basic function of Index in Oracle or any
databse.
Generally speaking,attaching index to a column in a table,
information of the location of the different values in the
indexed column is also provided.This address is like the
pointer varible in C,and in SQL it is called ROWID(a
pseudocolumn).Let us see he example ....

SQL>select * from students
where id=123;
Students is a databse table and ID is the column in the
table on which we create the index.

On execution of the above query, at first, the ROWID
corresponding to id=123 in students table is found.From
this rowid, the index value for the row of data which is
pointed to by ROWID is found(in very less time).And so the
row is idenified and the entire row data is displayed.
The above serach process is specifically called "TABLE
ACCESS FULL(USING ROWID)).

Explain self joins in oracle?

1063

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2059

---

What is an oracle table?

1035

---

What is null value in oracle?

1162

---

What is the relationship among database, tablespace and data file?

1039

---

Explain about functional dependency and its relation with table design?

1061

---

List out the difference between commit, rollback, and savepoint?

1096

---

How to create a stored function in oracle?

1158

---

How to display employee records who gets more salary than the average salary in the department?

1128

---

What is archive log in Oracle?

1185

---

Can we commit inside a function in oracle?

1016

---

State the difference between a primary key and foreign key?

999

---

What is a tns service name?

1058

---

What is execute immediate in oracle?

1078

---

Is there any function in oracle similar like group_concat of mysql?

1112

---