Answer / murthy

TRUNCATE:-IT WILL DELETE ALL THE EXISTING RECORDS IN A TABLE

SYNTAX:-TRUNCATE TABLE <TABLE NAME>

DELETE:-IT WILL DELETE THE RECORDS IN A TABLE DEPENDINFG ON
THE GIVEN CONDITION.

SYNTAX:-DELETE FROM <TABLE NAME> WHERE <CONDITON>


PURGE:-AFTER PERFOMING DROP OPERATION THE TABLES WILL STORE
AT UNDO LOGS SO TO DELETE THE DATA COMPLETELY FROM TAHE
DATA BASE WE WILL PURGE THE RECYCLEBIN.

SYNTAX:-PURGE RECYCLEBIN.

Answer / d.elumalai

DELETE:

1.DML Command.
2. Can be used with WHERE clause.
3. Can be rolled back.
4. Deletes table contents row by row when executed.
5. Delete is slow
6.Doesn't frees-up the Storage Space
7.Creates the log file
8.Returns the no. of rows deleted when queried.
9. Trigger gets fired incase of Delete.
10. Date gets copied into the Rollback tablespace after
Delete is executed.

TRUNCATE:

1.A DDL Command,
2.Can't be used with WHERE clause.
3.Can't be Rolled back.
4.Drops the entire table contents when executed but not the
table. [Note:DROP commnad deletes the entire contents along
with the table]
5.Truncate is faster.
6.Frees-up the Stroage Space
7. Doesn't create a log file
8.Doesn't return the no. of rows deleted when queried.
9.Trigger doesn't get fired incase of Truncate.
10.Data gets romoved directly without copying it into the
Rollback tablespace when truncate is executed.

Answer / papia

Truncate table removes all rows from the table and alos
releases the storage space and as it is a DDL statement so
no Rollback information is available
Delete statement also removes the row but does not release
the storage space
Truncate is faster than delete.

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

What is the basic structure of an sql?

0 Answers  

---

How to fix oracle error ora-00942: table or view does not exist

0 Answers  

---

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

---

Explain the concept of normalization.

3 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

How do I count rows in sql?

0 Answers  

---

What is having clause in sql?

0 Answers  

---