SQL> create table tmp_member
2 (
3 u_id number(10),
4 username varchar2(50) not null,
5 sex boolean not null default 'F',
6 regdate date default sysdate
7 );
sex boolean not null default false,
*
第 5 行出现错误:
ORA-00907: 缺失右括号怎么解决 ?
2 (
3 u_id number(10),
4 username varchar2(50) not null,
5 sex boolean not null default 'F',
6 regdate date default sysdate
7 );
sex boolean not null default false,
*
第 5 行出现错误:
ORA-00907: 缺失右括号怎么解决 ?
(
u_id number(10),
username varchar2(50) not null,
sex varchar2(1) default 'F',
regdate date default sysdate
);
SQL> create table tmp_member
2 (
3 u_id number(10),
4 username varchar2(50) not null,
5 sex char(1) default 'F',
6 regdate date default sysdate
7 );Table created
(
u_id number(10),
username varchar2(50) not null,
sex char(1) default 'F',
regdate date default sysdate
); 我也看了,这样能行吧!兄弟
AS
my_bool BOOLEAN := TRUE;
BEGIN
IF (in_bool = my_bool) THEN
DBMS_OUTPUT.PUT_LINE('True');
ELSE
DBMS_OUTPUT.PUT_LINE('False or NULL');
END IF;EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE('SQLERRM: ' || SQLERRM);
DBMS_OUTPUT.PUT_LINE('SQLCODE: ' || SQLCODE);
END BoolProc;Why is there no Boolean in Oracle for tables? What should we do instead? This:CREATE TABLE BoolTable (MyBool CHAR(1) CHECK (MyBool IN ( 'Y', 'N' )));