SQL

fonction stockée sql

SQL> create or replace procedure supp_art (numero in char) is
  2    begin
  3    delete from ligcdes where refart=numero;
  4    delete from articles where refart=numero;
  5    end;
  6  /

Procédure créée.

SQL>