What is the diff between Truncate table / delete <table
name> purge

Answer Posted / 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.

Is This Answer Correct ?    10 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger and types?

799


How will you distinguish a global variable with a local variable in pl/sql?

905


How do you update f as m and m as f from the below table testtable?

1571


what are the advantages and disadvantages of views in a database? : Sql dba

817


Is pl sql and postgresql same?

830


what is myisam? : Sql dba

793


What is pivot query?

868


is mysql query is case sensitive? : Sql dba

829


What is sql indexing?

790


What is form and report?

769


how many tables will create when we create table, what are they? : Sql dba

837


What are types of exception?

734


Can we write dml inside a function in sql server?

710


How do I create a memory optimized filegroup?

753


What is a natural join?

788