表结构
CREATE TABLE SCOTT.DEV_RH_LANCE
(
NO NUMBER(1, 0) NOT NULL CONSTRAINT NO CHECK (NO IN('1','2','3','4','5','6')),
SUM_TIMES NUMBER,
SUM_O2_CONS NUMBER,
SUM_BLOW_TIME NUMBER,
USING_TIME DATE
, CONSTRAINT DEV_RH_LANCE_PK PRIMARY KEY
(
NO
)
)
;
//执行以下语句
insert into scott.DEV_RH_LANCE(NO,SUM_TIMES) values(1,2);
select SUM_TIMES from scott.DEV_RH_LANCE where NO=1;//没有找到数据将SCOTT.DEV_RH_LANCE中CONSTRAINT NO CHECK (NO IN('1','2','3','4','5','6'))删除,select SUM_TIMES from scott.DEV_RH_LANCE where NO=1;就能够找到数据。提问:
怎样能够即加CONSTRAINT又能够查询?
CREATE TABLE SCOTT.DEV_RH_LANCE
(
NO NUMBER(1, 0) NOT NULL CONSTRAINT NO CHECK (NO IN('1','2','3','4','5','6')),
SUM_TIMES NUMBER,
SUM_O2_CONS NUMBER,
SUM_BLOW_TIME NUMBER,
USING_TIME DATE
, CONSTRAINT DEV_RH_LANCE_PK PRIMARY KEY
(
NO
)
)
;
//执行以下语句
insert into scott.DEV_RH_LANCE(NO,SUM_TIMES) values(1,2);
select SUM_TIMES from scott.DEV_RH_LANCE where NO=1;//没有找到数据将SCOTT.DEV_RH_LANCE中CONSTRAINT NO CHECK (NO IN('1','2','3','4','5','6'))删除,select SUM_TIMES from scott.DEV_RH_LANCE where NO=1;就能够找到数据。提问:
怎样能够即加CONSTRAINT又能够查询?
2 (
3 NO NUMBER(1, 0) NOT NULL CONSTRAINT NO CHECK (NO IN('1','2','3','4','5','6')),
4 SUM_TIMES NUMBER,
5 SUM_O2_CONS NUMBER,
6 SUM_BLOW_TIME NUMBER,
7 USING_TIME DATE
8 , CONSTRAINT DEV_RH_LANCE_PK PRIMARY KEY
9 (
10 NO
11 )
12 )
13 ;Table createdSQL> insert into t(NO,SUM_TIMES) values(1,2);1 row insertedSQL> select * from t where no=1;NO SUM_TIMES SUM_O2_CONS SUM_BLOW_TIME USING_TIME
-- ---------- ----------- ------------- -----------
1 2 SQL> commit;Commit completeSQL> select * from t where no=1;NO SUM_TIMES SUM_O2_CONS SUM_BLOW_TIME USING_TIME
-- ---------- ----------- ------------- -----------
1 2
2 (
3 NO NUMBER(1, 0) NOT NULL CONSTRAINT NO CHECK (NO IN('1','2','3','4','5','6')),
4 SUM_TIMES NUMBER,
5 SUM_O2_CONS NUMBER,
6 SUM_BLOW_TIME NUMBER,
7 USING_TIME DATE
8 , CONSTRAINT DEV_RH_LANCE_PK PRIMARY KEY
9 (
10 NO
11 )
12 )
13 ;表已创建。SQL>
SQL> insert into scott.DEV_RH_LANCE(NO,SUM_TIMES) values(1,2);已创建 1 行。SQL> commit;提交完成。SQL> select SUM_TIMES from scott.DEV_RH_LANCE where NO=1;未选定行SQL> select * from scott.DEV_RH_LANCE; NO SUM_TIMES SUM_O2_CONS SUM_BLOW_TIME USING_TIME
---------- ---------- ----------- ------------- --------------
1 2SQL>