The Deletecommand is used to remove the tuple from table.Through this command,you can delete the selected rows from the table.You can use Rollback and Commit statement after delete command.
Enter this command to calculate the number of rows
Code:
SQL> Select count(*) from my_table;
Delete the selected rows from table,The record which contains the Mem_post as a security would be deleted
Code:
SQL>Delete from my_table where Mem_post='Security';
Then enter the first command again to ensure number of rows.
Bookmarks