create type superman(superman_name nvarchar2(4) not null,superman_mobile varchar(18));--没有问题create table mysuper(myname nvarchar2(4) NOT NULL,
firstson superman,-------------invalid datatype
secondson superman);-----------invalid datatype
firstson superman,-------------invalid datatype
secondson superman);-----------invalid datatype
create type superman(superman_name nvarchar2(4) --type里面不要有控制约束not null,
superman_mobile varchar(18))
create type superman as object (superman_name nvarchar2(4),superman_mobile varchar(18));--没有问题create table mysuper(myname nvarchar2(4) NOT NULL,
firstson superman,-------------invalid datatype
secondson superman);-----------invalid datatype