Delete Command features and advantages:
- Command is for deleting the rows from the table.
- Can delete selective rows from the table using where clause.
- All rows can be deleted if no where clause is specified.
- It needs a commit or rollback command to complete the transaction or make it as permanent change.