create table tab1 (dep varchar2(10), val number);

insert all
into tab1 values ('a',10)
into tab1 values ('a',20)
into tab1 values ('a',30)
into tab1 values ('b',10)
into tab1 values ('b',20)
into tab1 values ('c',10)
select * from dual;