Oracle make_ref 报错 binary Number

来源:互联网 发布:协和 清华知乎 编辑:程序博客网 时间:2024/04/30 14:04
drop type  abcType force;
CREATE OR REPLACE TYPE abcType AS OBJECT(
  SHISAN_NO    NUMBER(20),
  SHISAN_EDABAN    NUMBER(3),
  SHISAN_MEISAI_NO  NUMBER(5),
  NENDO      number(4),
  NENDO_MEISHO    VARCHAR2(20)
);
/

drop table abcTable force;
create table abcTable of abcType(SHISAN_NO constraint pktes  primary key) OBJECT IDENTIFIER IS PRIMARY KEY;

select make_ref(abcTable, 1) from dual;
/
原创粉丝点击