Section courante

A propos

Section administrative du site

DELETE

Efface
Oracle Database SQL  

Syntaxe

DELETE [FROM] [schema.] table [@dblink] [alias]
   WHERE (condition)
      [RETURNING expr INTO DATA_ITEM]

DELETE [FROM] [schema.] table [SUB]PARTITION partition [alias]
   WHERE (condition)
      [RETURNING expr INTO DATA_ITEM]

DELETE [FROM] [schema.] view [@dblink] [alias]
   WHERE (condition)
      [RETURNING expr INTO DATA_ITEM]

DELETE [FROM] subquery [WITH READ ONLY] [alias]
   WHERE (condition)
      [RETURNING expr INTO DATA_ITEM]

DELETE [FROM] subquery [WITH CHECK OPTION] [CONSTRAINT constraint] [alias]
   WHERE (condition)
      [RETURNING expr INTO DATA_ITEM]

Description

Cette instruction permet de supprimer des enregistrements dans une table.

Voir également

Article - Les géants de l'informatique - Oracle

Dernière mise à jour : Lundi, le 11 mai 2015