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
What is trigger and types?
How will you distinguish a global variable with a local variable in pl/sql?
How do you update f as m and m as f from the below table testtable?
what are the advantages and disadvantages of views in a database? : Sql dba
Is pl sql and postgresql same?
what is myisam? : Sql dba
What is pivot query?
is mysql query is case sensitive? : Sql dba
What is sql indexing?
What is form and report?
how many tables will create when we create table, what are they? : Sql dba
What are types of exception?
Can we write dml inside a function in sql server?
How do I create a memory optimized filegroup?
What is a natural join?