1、 表结构和测试数据插入
建表:
-- Create table
create table TAB_FXHS
(
id VARCHAR2(32),
zt VARCHAR2(2)
);
-- Add comments to the table
comment on table TAB_FXHS
is '用于统计状态值全为正常的id值';
-- Add comments to the columns
comment on column TAB_FXHS.id
is '主键ID';
comment on column TAB_FXHS.zt
is '状态';
插入测试数据:
prompt Importing table TAB_FXHS...
set feedback off
set define off
insert into TAB_FXHS (ID, ZT)values ('10125', '0');
insert into TAB_FXHS (ID, ZT)values ('10161', '0');
insert into TAB_FXHS (ID, ZT)values ('10141', '0');
insert into TAB_FXHS (ID, ZT)values ('10126', '1');
insert into TAB_FXHS (ID, ZT)values ('10102', '