CREATE TABLE sitcoms 
(
	id 		NUMBER,
	sitcom	 	VARCHAR2(30),
	data 		XMLTYPE
);

INSERT INTO sitcoms (id, sitcom, data)
VALUES (1, 'Friends', xmltype('<friends>
	<characters>
		<character status="Lead" actorid="001">
			<firstname>Ross</firstname>
			<lastname>Geller</lastname>
			<gender>Male</gender>
			<birthdate>1967-10-18</birthdate>
			<occupation>Palaeontologist</occupation>
		</character>
		<character status="Lead" actorid="002">
			<firstname>Phoebe</firstname>
			<lastname>Buffay</lastname>
			<gender>Female</gender>
			<birthdate>1965-02-16</birthdate>
			<occupation>Masseuse</occupation>
		</character>
		<character status="Lead"  actorid="003">
			<firstname>Joey</firstname>
			<lastname>Tribiani</lastname>
			<gender>Male</gender>
			<birthdate>1968</birthdate>
			<occupation>Actor</occupation>
		</character>
		<character status="Lead" actorid="004">
			<firstname>Rachel</firstname>
			<lastname>Green</lastname>
			<gender>Female</gender>
			<birthdate>1971</birthdate>
			<occupation>Waitress</occupation>
		</character>
		<character status="Lead" actorid="005">
			<firstname>Monica</firstname>
			<lastname>Geller</lastname>
			<gender>Female</gender>
			<birthdate>1969-04-04</birthdate>
			<occupation>Chef</occupation>
		</character>
		<character status="Lead" actorid="006">
			<firstname>Chandler</firstname>
			<lastname>Bing</lastname>
			<gender>Male</gender>
			<birthdate>1968-04-08</birthdate>
			<occupation>Processing Manager</occupation>
		</character>
		<character status="Secondary" actorid="007">
			<firstname>Janice</firstname>
			<lastname>Goralnik</lastname>
			<gender>Female</gender>
		</character>
		<character status="Secondary" actorid="008">
			<firstname>Gunther</firstname>
			<gender>Male</gender>
			<occupation>Barista</occupation>
		</character>
	</characters>
	<cast>
		<actor id="001">
			<firstname>David</firstname>
			<lastname>Schwimmer</lastname>
			<birthdate>1966-11-02</birthdate>
		</actor>
		<actor id="002">
			<firstname>Lisa</firstname>
			<lastname>Kudrow</lastname>
			<birthdate>1962-07-30</birthdate>
		</actor>
		<actor id="003">
			<firstname>Matt</firstname>
			<lastname>LeBlanc</lastname>
			<birthdate>1967-07-25</birthdate>
		</actor>
		<actor id="004">
			<firstname>Jennifer</firstname>
			<lastname>Aniston</lastname>
			<birthdate>1969-02-11</birthdate>
		</actor>
		<actor id="005">
			<firstname>Courtney</firstname>
			<lastname>Cox</lastname>
			<birthdate>1964-06-15</birthdate>
		</actor>
		<actor id="006">
			<firstname>Matthew</firstname>
			<lastname>Perry</lastname>
			<birthdate>1969-08-19</birthdate>
		</actor>
		<actor id="007">
			<firstname>Maggie</firstname>
			<lastname>Wheeler</lastname>
			<birthdate>1961-08-07</birthdate>
		</actor>
		<actor id="008">
			<firstname>James</firstname>
			<lastname>Tyler</lastname>
			<birthdate>1962-05-28</birthdate>
		</actor>
	</cast>
</friends>')
);

INSERT INTO sitcoms (id, sitcom, data)
VALUES (2,'Episodes', xmltype('<episodes>
	<characters>
		<character status="Lead" actorid="003">
			<firstname>Matt</firstname>
			<lastname>LeBlanc</lastname>
			<gender>Male</gender>
			<birthdate>1967-07-25</birthdate>
			<occupation>Actor</occupation>
		</character>
		<character status="Lead" actorid="100">
			<firstname>Beverly</firstname>
			<lastname>Lincoln</lastname>
			<gender>Female</gender>
			<occupation>TV Producer</occupation>
		</character>
		<character status="Lead" actorid="101">
			<firstname>Sean</firstname>
			<lastname>Lincoln</lastname>
			<gender>Male</gender>
			<occupation>TV Producer</occupation>
		</character>
	</characters>
	<cast>
		<actor id="003">
			<firstname>Matt</firstname>
			<lastname>LeBlanc</lastname>
			<birthdate>1967-07-25</birthdate>
		</actor>
		<actor id="100">
			<firstname>Tamsin</firstname>
			<lastname>Greig</lastname>
			<birthdate>1966-07-12</birthdate>
		</actor>
		<actor id="101">
			<firstname>Stephen</firstname>
			<lastname>Mangan</lastname>
			<birthdate>1968-07-22</birthdate>
		</actor>
	</cast>
</episodes>')
);