what is difference between delete and truncet ?
Answer Posted / pooja
The DELETE statement is used to delete rows in a table.
Syntax:
DELETE FROM table_name
WHERE some_column=some_value
e.g.
DELETE FROM Persons
WHERE LastName='Tjessem' AND FirstName='Jakob'
Truncate:-
What if we only want to delete the data inside the table,
and not the table itself?
Then, use the TRUNCATE TABLE statement:
Syntax:
TRUNCATE TABLE table_name
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to produce such kind of file?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What is database collection?
What is the advantage of varchar2 over char?
What are different types of blocks used in stored procedure?
What is database schema name?
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
how can we view column head in first page but not in remaining pages?
what is rcp,if rcp disabled what happen?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
When should you not use firebase?
how node connect with cpu?
What are different types of resources?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?