Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15550 Views
- TCS, I also Faced
- E-Mail Answers
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 an invalid partition table?
What is varchar used for?
What are primary key and foreign key and how they work?
What are the sql versions?
How many types of keys are there in sql?
What are different types of sql commands?
what is data manipulation language? : Sql dba
Can we debug stored procedure?
List the ways to get the count of records in a table?
How can you view the errors encountered in a trigger?
What is a clob in sql?
How to display the current date in sql?
Can we update views in sql?
What is trigger explain with example?
Is not null in sql?
