1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| create table WB_SOFT
(
SOFT_SERVER_NAME varchar2(6),
SOFT_NAME varchar2(6)
);
insert into WB_SOFT (SOFT_SERVER_NAME, SOFT_NAME)
select 'SWT001', 'appli1' from dual union all
select 'SWT001', 'appli2' from dual union all
select 'SWT001', 'appli3' from dual union all
select 'SWT002', 'appli1' from dual union all
select 'SWT002', 'appli4' from dual;
commit;
select * from wb_soft;
SOFT_SERVER_NAME SOFT_NAME
SWT001 appli1
SWT001 appli2
SWT001 appli3
SWT002 appli1
SWT002 appli4 |