DELETE records from a table (DML Commands) | Oracle SQL fundamentals

Published: 27 December 2018
on channel: DBA Genesis
1,254
7

The SQL #DELETE statement is a used to delete one or more records from a #table.
If we want to delete the #rows in a table, we need to use #UPDATE #query in #SQL.
In delete Statement we use #WHERE Condition, if we do not use WHERE condition in delete statement then all the records of table will be deleted. so it is good practice to use where condition while using delete command in sql.

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis