Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


Oracle Delete All Rows Statement

The Oracle DELETE statement allows you to delete all records from a table within the database. By using delete statement, we can delete records on the basis of conditions.

Oracle DELETE FROM TABLE Syntax

To detele data from existing table, use the following syntax:

Syntax

DELETE FROM tablename WHERE Condition;

Parameters:

tablename: The table name from which you want to delete the data.

Condition: To check specific condition before delete the data. The conditions parameter is optional.

Oracle DELETE Data example for all records

The following Oracle statement to delete all records from "tblCustomerLoan" table:

Example

DELETE FROM tblCustomerLoan;

OR

DELETE * FROM tblCustomerLoan;

Note:

In the above example, we have deleted all the records for "tblCustomerLoan" table.