Answer Posted / ajeet singh

For delete any record from table :-

delete form <tablename> where <condition>;


For delete any column fromm table :-

alter table <tablename>
drop column <columnname>;

How can we find out the duplicate values in an oracle table?

1004

---

What is procedure overloading in oracle?

1003

---

How to convert times to characters in oracle?

987

---

How to run the anonymous block again?

1073

---

How to export several tables together?

998

---

What is a nested table?

1010

---

What are the limitations of check constraint?

974

---

How do I reset a sequence in oracle?

1062

---

How to name query output columns in oracle?

1143

---

Explain what does a control file contain?

1043

---

Difference between the “verify” and “feedback” command?

1319

---

What is the maximum limit on the number of columns in a table?

1024

---

What is the string concatenation operator in oracle?

1107

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

931

---

How to login to the server without an instance?

1115

---