I have table employee...which has two columns like....Name and Id...

create table employee(name varchar2(10),id number);


Insert into employee values('A',1);

Insert into employee values('B',2);

Insert into employee values('C',3);

Name id-----input.
A 4
B 2
C 3
D 1.

Now i need a output like in below.
Name id
A 4
A 4
A 4
A 4
B 2
B 2
C 3
C 3
C 3
D 1.