Oracle----Delete Data

1. Deleting data: Delete statement:

Grammar:

DELETE  from table_name;

(1), unconditional deletion:

SQL>createtable  testdel  2as  Select *  from userinfo; The table was created. SQL> Delete from Testdel; 4 rows deleted. SQL>Select* from testdel; rows not selected SQL>

(2), conditional removal:

Sql> SelectUsername fromUserInfo; USERNAME--------------------Xxxyyysql> Delete  fromUserInfowhereUsername='yyy'; deleted1line. SQL> SelectUsername fromUserInfo; USERNAME--------------------Xxxsql>

Oracle----Delete Data