1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
CREATE or REPLACE TYPE PERSONNEL AS object
(
id number(5),
nom varchar(20),
prenom varchar(20),
datenaiss DATE,
adresse varchar(80),
MEMBER PROCEDURE ajouter,
MEMBER FUNCTION getage(age IN NUMBER) RETURN NUMBER,
MEMBER PROCEDURE afficherinfo,
MEMBER FUNCTION modifadresse(adresse IN VARCHAR) RETURN VARCHAR
) instantiable not final;
/
CREATE TABLE absence_tb of absence(
constraint tababs_id primary key(id)
)
/
CREATE or replace TYPE BODY PERSONNEL as
(
MEMBER PROCEDURE ajouter is
begin
insert into personnel_tb (seq_personnel_tb.nextval,nom,prenom,datenaiss,adresse);
end;
MEMBER FUNCTION getage(age IN NUMBER) RETURN NUMBER is
begin
return(sysdate-datenaiss);
end; |
Partager