Oracle¶ÔÏóÀàÐÍÏê½â

³éÏóÊý¾ÝÀàÐÍ
1¡¢´´½¨ÀàÐÍ
--µØÖ·ÀàÐÍ
CREATE OR REPLACE TYPE AddressType AS OBJECT
(
Country varchar2(15),
City varchar2(20),
Street varchar2(30)
);
2¡¢ÀàÐÍǶÌ×
--´´½¨»ùÓÚÇ°Ò»¸öÀàÐ͵ÄеijéÏóÊý¾ÝÀàÐÍ£º¾ÞÐÇÀàÐÍ
CREATE OR REPLACE TYPE SuperStarType AS OBJECT
(
StarName varchar2(30),
Address AddressType
);
3¡¢»ùÓÚ³éÏóÀàÐÍ´´½¨¹Øϵ±í
CREATE TABLE SuperStar
(
StarID varchar(10),
Star SuperStarType
);
4¡¢»ùÓÚ³éÏóÀàÐÍ´´½¨¶ÔÏó±í
CREATE TABLE SuperStarObj of SuperStarType;
5¡¢Ê¹Óù¹Ôì·½·¨ÔÚ±íÖвåÈë¼Ç¼
INSERT INTO SuperStar VALUES(''001'',SuperStarType(''Zidane'',AddressType(''France'',''Paris'',''People Street NO.1'')));
6¡¢²éѯ±íÖмǼ
£¨1£©SQL> SELECT * from SuperStar;
STARID
----------
STAR(STARNAME, ADDRESS(COUNTRY, CITY, STREET))
--------------------------------------------------------------------------------
001
SUPERSTARTYPE(''Zidane'', ADDRESSTYPE(''France'', ''Paris'', ''People Street NO.1''))
£¨2£©
SELECT s.StarID,s.Star.StarName,s.Star.Address.Country,s.Star.Address.City,s.Star.Address.Street from SuperStar s
STARID STAR.STARNAME STAR.ADDRESS.CO STAR.ADDRESS.CITY STAR.ADDRESS.STREET
---------- ------------------------------ --------------- -------------------- ---------------------
001 Zidane France Paris People Street NO.1
7¡¢³éÏóÊý¾ÝÀàÐ͵ļ̳Ð
£¨1£©´´½¨Ò»¸öÀàÐÍ
CREATE OR REPLACE TYPE PersonType AS OBJECT
(
PersonName varchar(10),
PersonSex varchar(2),
PersonBirth date
) not final;
(2)ÅÉÉúÒ»¸öÀàÐÍ
CREATE OR REPLACE TYPE StudentType UNDER PersonType
(
StudentNO int,
StudentScore int
);
(3)²é¿´Êý¾Ý×Öµä
SQL> DESC StudentType
StudentType extends SYS.PERSONTYPE
Name
------------------------------------------------------------------------------
PERSONNAME
PERSONSEX
PERSONBIRTH
STUDENTNO
STUDENTSCORE
(4)´´½¨¶ÔÏó±í
CREATE TABLE student OF StudentType;
(5)Ïò¶ÔÏó±íÖвåÈëÊý¾Ý
INSERT INTO student VALUES(''Rose'',''nv'',to_date(''1983-05-02'',''yyyy-mm-dd''),1001,98);
(6) ²éѯÊý¾Ý
SQL> SELECT * f