What is the method for deleting a row of data in PL/SQL?
To delete a row of data, you can use the DELETE statement. The basic syntax of this statement is as follows:
DELETE FROM table_name
WHERE condition;
The table_name specifies the table from which data is to be deleted, and the condition is used to specify which rows of data to delete. If no condition is specified, all rows in the table will be deleted.
For instance, suppose we have a table called employees and we want to delete employee data with the last name Smith, we can use the following DELETE statement:
DELETE FROM employees
WHERE last_name = 'Smith';
After executing this statement, the data of employees with the last name Smith will be deleted from the table.