how to delete record in oracle


How to delete record in oracle

delete command is use to delete record in oracle.

When we want to delete few record then we have to pass where condition along with delete command.

When we want to delete all record then we no need to pass where condition.

Delete single record

>delete from table_name where column_name=old_value;

Example

>delete from student where roll =101;

Delete all record from table

>delete from table_name;

Example

>delete from student;






Full-stack web and mobile app development company Contact Us : Skype: indore.webcoder Email: info@w3sparks.com Sales: +91 8085506229