oracle boolean oracle 没有boolean,mysql用bit(1)而oracle可以用char(1) check(...(0,1))字段, 如: create table a ( a char(1) check (a in(0,1)))
看错拉,是枚举,不是布尔: baidu下,有如下实现方式:declare type v_recode_type is record(a int,b varchar2(100)); type a is table of v_recode_type index by binary_integer; v_a a;begin v_a(1).a:=1; v_a(1).b:='aaa'; dbms_output.put_line(v_a(1).a); dbms_output.put_line(v_a(1).b);end;
oracle 没有boolean,mysql用bit(1)而oracle可以用char(1) check(...(0,1))字段,
如:
create table a ( a char(1) check (a in(0,1)))
baidu下,有如下实现方式:declare type v_recode_type is record(a int,b varchar2(100)); type a is table of v_recode_type index by binary_integer; v_a a;begin v_a(1).a:=1; v_a(1).b:='aaa'; dbms_output.put_line(v_a(1).a); dbms_output.put_line(v_a(1).b);end;