<pre>
drop table xmovies cascade constraints;
create table xmovies(
  mno     number(5) primary key,
  movie   SYS.XMLType
);
insert into xmovies values(1,sys.XMLType.createXML('
<movie>
  <title>Godfather ,The</title>
  <year>1972</year>
  <directors>
    <director>Francis Ford Coppola</director>
  </directors>
  <genres>
    <genre>Crime</genre>
    <genre>Drama</genre>
  </genres>
  <plot>Son of a Mafia boss, previously uninvolved in the business, takes over when his father is critically wounded in a mob hit.</plot>
  <cast>
    <performer>
      <actor>Marlon Brando</actor>
      <role>Don Vito Corleone</role>
    </performer>
    <performer>
      <actor>Al Pacino</actor>
      <role>Michael Corleone</role>
    </performer>
    <performer>
      <actor>Diane Keaton</actor>
      <role>Kay Adams Corleone</role>
    </performer>
    <performer>
      <actor>Robert Duvall</actor>
      <role>Tom Hagen</role>
    </performer>
    <performer>
      <actor>James Caan</actor>
      <role>Sonny Corleone</role>
    </performer>
  </cast>
</movie>'));

insert into xmovies values(2,sys.XMLType.createXML('
<movie>
  <title>Shawshank Redemption, The</title> 
  <year>1994</year>
  <directors>
    <director>Frank Darabont</director>
  </directors>
  <genres>
    <genre>Drama</genre>
  </genres>
  <plot>The life of Andy Dufresne changes when he is convicted and jailed for the murder of his wife. 
  </plot>
  <cast>
    <performer>
      <actor>Tim Robbins</actor>
      <role>Andy Dufresne, Inmate 37927</role>
    </performer>
    <performer>
      <actor>Morgan Freeman</actor>
      <role>Ellis Boyd "Red" Redding, Inmate 30265:Narrator</role>
    </performer>
    <performer>
      <actor>Bob Gunton</actor>
      <role>Warden Samuel Norton</role>
    </performer>
    <performer>
      <actor>William Sadler</actor>
      <role>Heywood, Inmate 32365</role>
    </performer>
    <performer>
      <actor>Clancy Brown</actor>
      <role>Captain Byron Hadley</role>
    </performer>
  </cast>
</movie>'));

insert into xmovies values(3,sys.XMLType.createXML('
<movie>
  <title>Schindlers List</title>
  <year>1993</year>
  <directors>
    <director>Steven Spielberg</director>
  </directors>
  <genres>
    <genre>Drama</genre>
    <genre>War</genre>
  </genres>
  <plot>Oskar Schindler uses Jews to start a factory in Poland during the war. He witnesses the horrors endured by the Jews, and starts to save them.
  </plot>
  <cast>
    <performer>
      <actor>Liam Neeson</actor>
      <role>Oskar Schindler</role>
    </performer>
    <performer>
      <actor>Ben Kingsley</actor>
      <role>Itzhak Stern</role>
    </performer>
    <performer>
      <actor>Ralph Fiennes</actor>
      <role>Amon Goeth</role>
    </performer>
    <performer>
      <actor>Caroline Goodall</actor>
      <role>Emilie Schindler</role>
    </performer>
    <performer>
      <actor>Jonathan Sagall</actor>
      <role>Poldek Pfefferberg</role>
    </performer>
  </cast>
</movie>'));

insert into xmovies values(4,sys.XMLType.createXML('
<movie>
  <title>Citizen Kane</title>
  <year>1941</year>
  <directors>
    <director>Orson Welles</director>
  </directors>
  <genres>
    <genre>Crime</genre>
    <genre>Sled</genre>
  </genres>
  <plot>Powerful newspaper owner Charles Foster Kane was many things to many people, both in life and, as seen in retrospective here, in death.
  </plot>
  <cast>
    <performer>
      <actor>Orson Welles</actor>
      <role>Charles Foster Kane</role>
    </performer>
    <performer>
      <actor>Joseph Cotten</actor>
      <role>Jedediah Leland</role>
    </performer>
    <performer>
      <actor>Dorothy Comingore</actor>
      <role>Susan Alexander Kane</role>
    </performer>
    <performer>
      <actor>Agnes Moorehead</actor>
      <role>Mrs. Mary Kane</role>
    </performer>
    <performer>
      <actor>Ruth Warrick</actor>
      <role>Emily Norton Kane</role>
    </performer>
  </cast>
</movie>'));

insert into xmovies values(5,sys.XMLType.createXML('
<movie>
  <year>1942</year>
  <directors>
    <director>Michael Curtiz</director>
  </directors>
  <genres> 
    <genre>Drama</genre>
    <genre>Romance</genre>
  </genres>
  <plot>Rick Blaine, a callous nightclub owner in a wartime waystation, has his world turned upside down when his lost love, Ilsa, returns. 
  </plot>
  <cast>
    <performer>
       <actor>Humphrey Bogart</actor>
       <role>Rick Blaine</role>
    </performer>
    <performer>
       <actor>Ingrid Bergman</actor>
       <role>Ilsa Lund Laszlo</role>
    </performer>
    <performer>
       <actor>Paul Henreid</actor>
       <role>Victor Laszlo</role>
    </performer>
    <performer>
       <actor>Claude Rains</actor>
       <role>Captain Louis Renault </role>
    </performer>
    <performer>
       <actor>Conrad Veidt</actor>
       <role>Major Heinrich Strasser</role>
    </performer>
  </cast>
</movie>'));
</pre>
