Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15571 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 does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What are the types of join in sql?
What is a boolean in sql?
What is trigger types of trigger?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Can you upgrade sql express to full sql?
What is the difference between the implicit and explicit cursors?
Define commit?
what is user defined functions? : Sql dba
Does sql profiler affect performance?
What are sql built in functions?
Can we change the table name in sql?
Why functions are used in sql?
What are pl/sql cursors?
