The Oracle DELETE statement allows you to delete single or multiple 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:
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.
In the above example, we have deleted the record for customer "Sunil Shetty".