oracle 查询高级用法,【已解决】关于Oracle分组函数高级用法（按照N条分组并生成唯一号）...

prompt PL/SQL Developer import file

prompt Created on 2018年3月30日 by

set feedback off

set define off

prompt Creating T_TEST_GROUP...

create table T_TEST_GROUP

(

code     VARCHAR2(100),

supplier VARCHAR2(100),

item_id  VARCHAR2(100),

num      NUMBER,

lot      VARCHAR2(100),

wh_id    VARCHAR2(100),

user_id  VARCHAR2(100)

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

next 8K

minextents 1

maxextents unlimited

);

prompt Disabling triggers for T_TEST_GROUP...

alter table T_TEST_GROUP disable all triggers;

prompt Loading T_TEST_GROUP...

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('CG01', 'S0002', '100013', 400, 'P16', '1000', '100');

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('CG01', 'S0002', '100015', 500, 'P20', '1000', '100');

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('CG01', 'S0003', '100002', 10, 'P03', '1000', '200');

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('CG01', 'S0002', '100001', 20, 'P02', '1000', '100');

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('CG01', 'S0001', '100000', 10, 'P01', '1000', '100');

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('TH01', 'S0005', '100004', 40, 'P04', '1000', '200');

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('TH01', 'S0005', '100005', 22, 'P05', '1000', '200');

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('TH01', 'S0002', '100012', 300, 'P10', '1000', '100');

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('CG01', 'S0002', '100011', 200, 'P12', '1000', '100');

insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)

values ('CG01', 'S0003', '100010', 100, 'P13', '1000', '100');

commit;

prompt 9 records loaded

prompt Enabling triggers for T_TEST_GROUP...

alter table T_TEST_GROUP enable all triggers;

set feedback on

set define on

prompt Done;