----------------------------------------------------------------------------------- This SQL file builds the tables for objects data---------------------------------------------------------------------------------set echo on;drop type address force;create type address as object (city varchar2(20), zip varchar2(10)); /drop type person force;drop table person_tab;create type person as object ( name varchar2(20), age number, addr address); /create table person_tab of person;insert into person_tab values('Nasser',40, address('Pleasanton', '94065'));insert into person_tab values('Maha', 25, address('Belmont', '94002'));insert into person_tab values('Chris',30, address('San Francisco', '94123'));insert into person_tab values('Gopal',28, address('Fremont', '11111'));insert into person_tab values('Ashish',27, address('San Jose', '22222'));/
参考下面的做法:--创建对象类型 create type person as object ( firsr_name varchar2(10), last_name varchar2(10), age number(3) ) /--根据类型创建表 create table persons of person /--插入数据 insert into persons values(person('Din','Ya',99))
/drop type person force;drop table person_tab;create type person as object ( name varchar2(20), age number, addr address);
/create table person_tab of person;insert into person_tab values('Nasser',40, address('Pleasanton', '94065'));insert into person_tab values('Maha', 25, address('Belmont', '94002'));insert into person_tab values('Chris',30, address('San Francisco', '94123'));insert into person_tab values('Gopal',28, address('Fremont', '11111'));insert into person_tab values('Ashish',27, address('San Jose', '22222'));/
create type person as object
(
firsr_name varchar2(10),
last_name varchar2(10),
age number(3)
)
/--根据类型创建表
create table persons of person
/--插入数据
insert into persons values(person('Din','Ya',99))