insert into table1 (学号,姓名,地址) values('123','123',to_char('test,test,test,test'))
按你说的做提示类型错误,以下是我建表代码,你看下 create type sys.address as object("county" varchar(10),"province" varchar(10))create type sys.student as object ("stuno" number(8,0),"name" varchar(10),"add" sys.address)
create table sys.stud of sys.student
为什么你不新建一个用户,而要用SYS用户来操作?
--eg: insert into sys.stud values(1,'123',sys.address('100','1000'))
create type sys.address as object("county" varchar(10),"province" varchar(10))create type sys.student as object ("stuno" number(8,0),"name" varchar(10),"add" sys.address)
create table sys.stud of sys.student
--eg:
insert into sys.stud
values(1,'123',sys.address('100','1000'))