drop table sejour;
drop table client;

create table sejour (
    description xmltype
);

create table client (
  idClient number(7) primary key,
  nom varchar2(30) not null,
  prenom varchar2(30) not null,
  dateNaissance date not null,
  adresse varchar2(100),
  chiffreAffaire number(12) default 0
);