Answer / Sourav Yadav

To rename an index in Oracle, you need to use the ALTER INDEX command. Here is an example:n```sqlnalter index your_index rename to new_index_name;n```

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1 Answers  

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1 Answers  

---

how may join possible between (requisition with purchase order)

1 Answers  

---

What do you mean by merge in oracle?

1 Answers  

---

How to assign values to variables?

1 Answers  

---

What is forall Statement ?

2 Answers   Thermotech,

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

2 Answers   Oracle,

---

State the various uses of dbcc command?

1 Answers  

---

Explain the features of oracle?

1 Answers  

---

What is Java Pool in Oracle?

1 Answers   MCN Solutions,

---

What are the uses of Database Trigger ?

1 Answers  

---

What is the difference between pre-select and pre-query?

1 Answers  

---