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.
To detele data from existing table, use the following syntax:
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.
Note:
In the above example, we have deleted all the records for "tblCustomerLoan" table.