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 PL/SQL Quick Help : Developers

A PL/SQL Block consists of three sections: 1.The Declaration section (optional). 2.The Execution section (mandatory). 3.The Exception (or Error) Handling section (optional). Sample below : […]

Oracle 9i Tutorial : ALTER TABLE Statement

 ALTER TABLE Statement          After you create a table, you may need to change the table structure because: you omitted column, your column definition needs […]

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 […]

Leave a Reply

Discover more from Abhyas

Subscribe now to keep reading and get access to the full archive.

Continue reading