Answer Posted / oracle_tigress

difference between truncate and delete

1.truncate removes rows in one execution..delete removes
rows one by one so truncate is fast..

2.truncate does not creates logs and hence canot be
rolledback and hence is a DDL stmt..DELETE creates rollback
segment hence can be rolled back and hence is a DML stmt.

3.truncate doesnot allow for conditional remove of records
(all records has to remove) DELETE allows conditonal remove
of records(where cluase etc can be used.)

4.triggers are not fired on truncate stmt but trgieers are
fired on DELETE stmt..

How to run pl sql program in mysql?

1071

---

What are joins in sql?

1108

---

What is output spooling in sql*plus?

1089

---

How long it takes to learn pl sql?

1064

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1146

---

Is sql a case sensitive language?

1008

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1247

---

What is pl/sql table? Why it is used?

1078

---

Does sql use python?

1095

---

What is the purpose of primary key?

1070

---

How do you modify a table in sql?

1162

---

What is the basic form of sql query?

992

---

What is the difference between clustered and non-clustered indexes?

1128

---

What are literals in sql server?

1256

---

How to write pl sql program in mysql command prompt?

1163

---