Partie pratique des packages oracle
voici le scripte que j'ai créer
create table etudiant
(etudiant_id number,
nom varchar2(100),
date_naissance date,
constraint etudiant_pk primary key (etudiant_id)
);
create sequence etudiant_seq;
create or replace package etudaint_generale
is
procedure insert_etudiant
(p_nom varchar2, p_date_naissance date);
procedure delete1_etudiant1
(p_etudiant_id number);
function get_nom
(p_etudiant_id number)
return varchar2;
end;
create or replace package body etudaint1_generale1
is
procedure insert_etudiant
(p_nom varchar2, p_date_naissance date)
is
begin
insert into etudiant
values(etudiant_seq.nextval,p_nom,p_date_naissance);
commit;
exception
when others then
dbms_output.put_line(sqlcode);
dbms_output.put_line(sqlerrm);
end;
procedure delete_etudiant
(p_etudiant_id number)
is
begin
delete from etudiant
where etudaint_id=p_etudiant_id;
commit;
exception
when others then
dbms_output.put_line(sqlcode);
dbms_output.put_line(sqlerrm);
end;
function get_nom
(p_etudiant_id number)
return varchar2
is
v_nom etudiant.nom%type;
begin
select nom into v_nom
from etudiant
where etudiant_id=p_etudiant_id;
return v_nom;
exception
when others then
return null;
end;
end;
execute etudaint_generale.insert_etudiant ('mouhiha mohamed','14-june-2000');
execute etudaint_generale.insert_etudiant ('tp_package','18-june-2021');
select * from etudiant;
execute etudaint_generale.delete_etudiant(1);
select * from etudiant;
select etudaint_generale.get_nom(2) from dual;
--exception
select etudaint_generale.get_nom(3) from dual;
DROP PACKAGE BODY etudaint_generale;
DROP PACKAGE etudaint_generale ;