Answer Posted / udhayakumar
delete is used to delete one or more rows from the table
where as truncate to delete all the rows without its
structure from the table
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Are subqueries better than joins?
What is the use of nvl function?
tell us something about heap tables. : Sql dba
What is the command used to fetch first 5 characters of the string?
How do you rank data in sql?
How many types of keys are there in sql?
What are types of indexes in sql?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
what are the difference between clustered and a non-clustered index? : Sql dba
How to set up sql*plus output format in oracle?
How many row comparison operators are used while working with a subquery?
What is sql catalog?
Why triggers are used?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
what are tables and fields? : Sql dba