Answer Posted / surendra

truncate

it deletes only the records from the table
it doesn't delete the structure of the table
we cannot rollback it
we cannot delete a particular record from the table
it is ddl

drop

it deletes the records as well as structure of the table too
we cannot rollback the records
we can flashback the table from the version 9x
it is ddl

delete

it deletes the only records which are we mention in the where clause or whole records
it is dml
we can rollback it

Is java required for oracle client?

1042

---

What happens if recursive calls get out of control?

1136

---

How to use an explicit cursor without open statements?

1097

---

Briefly explain what is literal? Give an example where it can be used?

1087

---

Explain the use of analyse option in exp command.

1185

---

How to drop a stored function?

1180

---

How to create a testing table in oracle?

1031

---

How to compare dates in oracle sql?

1156

---

How to get the Installed Oracle Version Information ?

1184

---

please explain.. DB architecture ...

2078

---

How to create a single index for multiple columns?

1078

---

Can objects of the same schema reside in different tablespace?

1101

---

Hi Can any one tell me what are the API's used in requisition import.

1964

---

What is bulk collect in oracle?

1051

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2438

---