What is the difference between DELETE and TRUNCATE?
Answer Posted / babloo
when truncate command is issued, all the rows from the
table are deleted and the memory space occupied by the
table in the tablespace is also released whereas when
delete command is issued, only all the rows are deleted
fronm the table
Is This Answer Correct ? | 28 Yes | 0 No |
Post New Answer View All Answers
how to do backup entire database? : Transact sql
What is online transaction processing (oltp)?
How to create your own reports in sql developer?
Why we use pl sql?
How do I save a stored procedure?
What is mutating error in pl sql?
What is right join in sql?
How to test for null values?
What are expressions?
How do I create a sql script?
how to show all tables with 'mysql'? : Sql dba
What do you understand by pl/sql packages?
How many tables can a sql database have?
Can we update views in sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..