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
|
create type typ_vehicule; -- type incomplet--
create type typ_station as object(
num_station number(10),
nom_station varchar2(10))
create type typ_tab_station as table of ref typ_station;
create type typ_array_tarif as varray(3) of number(4,2);
create type typ_circuit as object (
vehicule ref typ_vehicule,
stations typ_tab_station,
tarif typ_array_tarif );
--déclaration complète du type : typ_vehicule
create type typ_voyage as object (
jour varchar2(10),
circuit ref typ_circuit,
frequence number(10),
début number (4,2),
fin number (4,2) );
create type typ_tab_voyage as table of typ_voyage ;
create type typ_planning as object (
identifiant number (10),
voyage typ_tab_voyage ) ;
create or replace type typ_vehicule as object(
matricule number(10),
planning typ_planning,
societé ref typ_societe); |
Partager