USING DELETE

This can be used to delete the table data temporarily.

Syntax:

    Delete [from] <table_name> where <condition>;

Ex:

     SQL> delete from student;

     If you are not specifying any condition this will delete entire table.

     SQL> delete from student where no = 2;