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

Опубликовано: 27 Декабрь 2018
на канале: 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