Answer / Sulabh Trivedi

To rename a column in an existing table, you can use the ALTER TABLE statement. Here's an example:nn`ALTER TABLE existing_table RENAME COLUMN old_column_name TO new_column_name;`

what is the use of rank function?

1 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

What is STATSPACK tool?

3 Answers   Wipro,

---

Can we write dml statement in function in oracle?

1 Answers  

---

What is an Oracle Instance?

1 Answers  

---

What is SQL Tuning Advisor in Oracle?

1 Answers   MCN Solutions,

---

What is recovery manager in Oracle?

1 Answers   MCN Solutions,

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1 Answers  

---

What is oracle rownum?

1 Answers  

---

What is a Private Synonyms ?

1 Answers  

---

Explain the use of owner option in exp command.

1 Answers  

---

10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables

6 Answers   Mind Tree,

---