What is the difference between DELETE and TRUNCATE?
Answer Posted / shilpa
Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the basic form of sql query?
How to place comments in pl/sql?
What is a record in a database?
Explain the purpose of %type and %rowtype data types?
Is sql a dbms?
Do prepared statements prevent sql injection?
What is record type in pl sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Can instead of triggers be used to fire once for each statement on a view?
What is sql resultset?
How do you use a while loop in pl sql?
Mention what is the use of function "module procedure" in pl/sql?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Can we edit a view in sql?
What is query execution plan in sql?