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
4.3
Overall Rating
70%
10%
10%
0%
10%
Reviews
A
Abhishek vishwkarma
5
kya SQL ke liye MYSQL use kar sakte hai ya koi specific server hi use karna hoga
V
Vishnu Suvaliya
5
Forums.learnvern.com cant work
A
Ankush Raj
5
good
R
ruhina qureshi
5
Awesome Classes ,Both tutors explains the concept very nice
Y
Yadav Aakash
5
very useful thank you learnvern
A
Ashish
5
The course is very good. I have stuck at a point that how you create multiple rows with a single insert in sales.customer table. I get only one customer data. this table is related to bikestore data.
Share a personalized message with your friends.