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

How many types of tables are there?

725


What is the difference between an inner join and an outer join?

750


what is an extent ? : Sql dba

774


What are the different sql languages?

780


How to run sql statements with oracle sql developer?

818


define sql delete statement ? : Sql dba

777


How many row comparison operators are used while working with a subquery?

779


How can you view the errors encountered in a trigger?

767


what is sql? : Sql dba

765


What is difference between sql and mysql?

791


What is a rank in sql?

732


Can you upgrade sql express to full sql?

741


how many sql dml commands are supported by 'mysql'? : Sql dba

827


What are triggers and its types?

800


what are all the different normalizations? : Sql dba

711