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.5
Overall Rating
74%
16%
5%
0%
5%
Reviews
M
Mahima Patel
5
very usefull......thanks
P
Priya Kushwaha
5
Very Good trainer
C
chanchal singh
5
you guys are doing nice job. thanks
U
Umesh Wankhede
5
Not too much interactive
M
Monesh Ram
5
Well Explained in Every Chapters..
G
GAJANAN DIGAMBAR MODE
5
very easy to understand SQL its was dream to learn SQL. Thanx for Learnvern
M
Mohmad Shadab
5
BEST VIDEOS
N
NAGASWETHA
5
very useful
M
mohd aamir
4
Hi Team,
Why you didn't teach/learn how to write select query, even you shared 15 question for practice :(
Y
Yashvant Kadwe
5
I have found the course to be interesting with plenty of valuable information provided as part of the course and through interaction with fellow teachers and trainers from a wide range of disciplines
Share a personalized message with your friends.