分析函数应用一例（查找状态全为1的ID）

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', '