XML——管理資料交換/資料庫和 XML/問答

CREATE TABLE Movies (doc VARCHAR(150));

INSERT INTO Movies VALUES
('
<movie id="1">
      <mtitle>Office Space</mtitle>
      <mlength>89 min</mlength>
      <mrating>R</mrating>
</movie>
');

INSERT INTO Movies VALUES
('
<movie id="2">
      <mtitle>The Ghost and the Darkness</mtitle>
      <mlength>109 min</mlength>
      <mrating>R</mrating>
</movie>
');

INSERT INTO Movies VALUES
('
<movie id="3">
      <mtitle>Donnie Darko</mtitle>
      <mlength>118 min</mlength>
      <mrating>R</mrating>
</movie>
');