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 write a query to show the details of a student from students table whose

993

---

What is oracle and pl sql?

1116

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2109

---

What is query syntax?

961

---

Is sql pronounced sequel or sql?

1260

---

What are the key differences between SQL and PL SQL?

1211

---

how to use case expression? : Sql dba

1018

---

How many sql statements are used?

1006

---

What is cursor and why it is required?

1178

---

How we can update the view?

1048

---

what is query cache in mysql? : Sql dba

1029

---

What is a common use of group by in sql?

1045

---

Write the alter statement to enable all the triggers on the t.students table.

1123

---

What are stored procedures in mysql?

1015

---

What is the difference between functions, procedures, and packages in pl/sql?

1041

---