To erase existing records in a table, use the DELETE statement.
In an Oracle database, there is no difference between delete and delete from; yet, writing code like this is typical. [WHERE condition] DELETE FROM table This conforms to the SQL-92 standard.
To eliminate all records, the SQL Truncate statement locks the table and page. The Delete command creates a record in the transaction log for each removed row. The truncate command does not add entries to the transaction log for each removed row. The Delete command is more time consuming than the Truncate command.
Learner's Ratings
3.8
Overall Rating
48%
17%
9%
17%
9%
Reviews
S
Swati Patil
5
Excellent
A
Avinash Rawat
4
I want to assignment answer and data. excellent teach
rawatavinash1995@gmail.com
P
Pravin Kashid
5
excellent teaching technique...one of the best course content...
Share a personalized message with your friends.