Delete Oracle | Delete - oracle tutorial - sql tutorial

Oracle delete row using where

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


DELETE FROM table_name WHERE conditions;
click below button to copy the code. By - oracle tutorial - team

Parameters or Arguments:


  • 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.
Oracle delete table

SQL Delete Table


DELETE FROM wikitechy_emp WHERE Name = 'Venkat';
click below button to copy the code. By - oracle tutorial - team


 oracle delete select output
  1. Before the Delete query statement execution , this is how the wikitechy_emp table is as shown above .
 oracle delete query
  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.
 oracle delete output
  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

Related Searches to Delete Oracle | Delete

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add to your ad blocking whitelist or disable your adblocking software.