Learn oracle - oracle tutorial - Oracle delete row using where - oracle examples - oracle programs

What is Oracle DELETE ?

• The Oracle DELETE statement is used to delete a single record or multiple records from a table in Oracle.

oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

Syntax:

DELETE FROM table_name WHERE conditions;

click below button to copy the code. By - oracle tutorial - team

Copy Code

Parameters or Arguments:

table

• The table that you wish to delete records from.

WHERE conditions

• Optional. The conditions that must be met for the records to be deleted. If no conditions are provided, then all records from the table will be deleted.

SQL Delete Table

Example:

DELETE FROM wikitechy_emp WHERE Name = 'Venkat';

click below button to copy the code. By - oracle tutorial - team

Copy Code

Screenshot:

1. Before the Delete query statement execution , this is how the wikitechy_emp table is as shown above .

1. Here we have deleted the Name ‘Venkat’ in the table by using DELETE Statement .
2. Click Run button to execute the query.
3. We can see the rows which has been successfully deleted in the wikitech_emp table.

1. After the Delete query execution , the Name value ‘Venkat’ has been deleted from the table ‘wikitechy_emp’.

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning