Oracle 9i Tutorial : What is syntax of DELETE Statement Syntax

You can remove existing rows by using the DELETE statement.

Delete Statement Syntax below :

  DELETE [FROM]    table

  [WHERE    condition];

Related Posts

Oracle 9i Tutorial – Database Objects

Database Objects An Oracle database can contain multiple data structures. Each structure should be outlined in the database design so that it can be created […]

Oracle 9i Tutorial : UPDATE Statement Syntax

UPDATE Statement Syntax Update Statement is used to modify existing rows in table. Below is Update State Syntax : UPDATE  table SET  column = value […]

Oracle 9i Tutorial : Drop,Rename and Truncate table

DROP TABLE   Remove rows and a table structure.   Once executed, this statement cannot be rolled   back.   -DROP TABLE EMPLOYEE RENAME   […]

Leave a Reply