Aide-mémoire SQL Oracle

Requêtage INSERT, UPDATE, DELETE INSERT Exemple 1: INSERT INTO Table(nom colonnes) values (valeurs) Exemple 2: INSERT INTO Table(nom colonnes) SELECT colonnes FROM Table2 WHERE … Remarque: Possible d’utiliser le mot clé EXISTS INSERT INTO clients (client_id, client_name, client_type) SELECT supplier_id, supplier_name, ‘advertising’ FROM suppliers WHERE not exists (select * from clients where clients.client_id = suppliers.supplier_id);…

Continuer à lire