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
How many types of tables are there?
What is the difference between an inner join and an outer join?
what is an extent ? : Sql dba
What are the different sql languages?
How to run sql statements with oracle sql developer?
define sql delete statement ? : Sql dba
How many row comparison operators are used while working with a subquery?
How can you view the errors encountered in a trigger?
what is sql? : Sql dba
What is difference between sql and mysql?
What is a rank in sql?
Can you upgrade sql express to full sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
What are triggers and its types?
what are all the different normalizations? : Sql dba