ORACLE
ORACLE QUERIES
SELECT
INSERT
INSERT ALL
UPDATE
DELETE
TRUNCATE TABLE
ORACLE TUTORIAL
Oracle Introduction
What Is Oracle
ORACLE TABLES
Create Tables
Create Table As
Alter Table
Drop Table
Global Temorary Tables
Local Temorary Tables
ORACLE VIEWS
Create View
ORACLE CLAUSES
DISTINCT
FROM
ORDER BY
GROUP BY
HAVING
ORACLE OPERATORS
UNION
UNION ALL
INTERSECT
MINUS
ORACLE JOINS
INNER JOIN
OUTER JOIN
EQUI JOIN
SELF JOIN
CROSS JOIN
ANTI JOIN
SEMI JOIN
ORACLE ADVANCE
PROCEDURES
FUNCTION
CURSOR
TRIGGER

DELETE



Oracle - Delete


In Oracle, DELETE statement is used to remove or delete a single record or multiple records from a table.


Syntax :
DELETE FROM table_name  
WHERE conditions;   

Parameters :

  • table_name: It specifies the table which you want to delete.

  • conditions: It specifies the conditions that must met for the records to be deleted.


    Lets take an example of table containing 'customers' info to perform delete query :

    Customer_idnamelastnamecity
    1MeherishChowdaryGujarat
    2AjaashiNehraMaharashtra
    3KaivalyaBhoopalamKarnataka

    Oracle Delete Example: On one condition


    DELETE FROM customers  
    WHERE name = 'Kaivalya';     
    

    As a result,table displays as follows :

    Customer_idnamelastnamecity
    1MeherishChowdaryGujarat
    2AjaashiNehraMaharashtra

    Oracle Delete Example: On multiple conditions


    DELETE FROM customers  
    WHERE last_name = 'Nehra'  
    AND customer_id = 2;  
    

    As a result,table displays as follows :


    Customer_idnamelastnamecity
    1MeherishChowdaryGujarat


    What Is Oracle

    What Is Oracle

    posted on 2019-11-29 01:11:21 - ORACLE Tutorials


    TRIGGER

    ORACLE - Trigger

    posted on 2019-11-28 22:14:22 - ORACLE Tutorials


    CURSOR

    ORACLE - Cursor

    posted on 2019-11-28 22:13:54 - ORACLE Tutorials


    MySQL TRIGGERS

    MySQL - Triggers

    posted on 2019-11-29 21:44:07 - mysql Tutorials


    Grant_ Revoke Privilege

    MySQL - Grant_ Revoke Privilege

    posted on 2019-11-26 23:15:04 - mysql Tutorials


    MySQL Vs SQL

    MySQL Vs SQL

    posted on 2019-11-25 05:02:26 - mysql Tutorials