Answer / Suraj Prakash Tiwari

To rename an index in Oracle Database, you can use the `ALTER INDEX` command with the `RENAME` option like this: `ALTER INDEX <index_name> RENAME TO <new_index_name>;`

1) Does oracle have any table which contain all the exceptions and it's code internally?

1 Answers   CTS,

---

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  

---

what is primary key and foreign key when and where have to use

5 Answers  

---

what is the uses of cusor

3 Answers   Perot Systems,

---

How to find the duplicate rows count from employees table in oracle?

1 Answers  

---

when loggined as SYSTEM,how to display all the users of database using sql query?

2 Answers  

---

What is key preserved table?

1 Answers  

---

How to grant create session privilege to a user in oracle?

1 Answers  

---

What are the different approaches used by Optimizer in choosing an execution plan ?

2 Answers  

---

What is different bet native dynamic sql and Dbms_Sql?

4 Answers   Thermotech,

---

How to start your 10g xe server from command line?

1 Answers  

---

What is meant by an index?

1 Answers  

---