需要有关Oracle 10g express版的帮助
当我尝试在下面的表格中插入记录时，我收到错误“ora-03001：未实现的功能”。我整晚都在搜索，但仍然没有运气。我正在使用Oracle10g快递版。
create or replace type MajorsType As varray(20) of varchar2(10);
create or replace type studenttype as object (
stuID varchar2(5),
lastName varchar2(15),
firstName varchar2(12),
majors MajorsType)
INSTANTIABLE
NOT FINAL;
create table Student of StudentType (
constraint student_stuID_pk PRIMARY KEY(stuID));
INSERT INTO student values StudentType ('S999', 'Smith', 'John', MajorsType('Math', 'Accounting'));
没有找到相关结果
已邀请:
1 个回复
娜拐赐巫潭
SQL> INSERT INTO student 2 values ( StudentType ('S999', 'Smith', 'John', MajorsType('Math', 'Accounting'))) 3 / 1 row created. SQL>declare r23 t23%rowtype; -- record declaration begin r23.id := 1; r23.created := sysdate; -- insert using record variable insert into t23 values r23; end;