omegamark
08-15-2001, 06:21 PM
Normally when we select we get records like
empno deptno
34 10
35 10
36 10
37 20
38 20
39 20
i need to get the records like
deptno empno empno empno
10 34 35 36
20 37 38 39
In access we will be able to do this with transform with columns .how about this in oracle in sql statement.
empno deptno
34 10
35 10
36 10
37 20
38 20
39 20
i need to get the records like
deptno empno empno empno
10 34 35 36
20 37 38 39
In access we will be able to do this with transform with columns .how about this in oracle in sql statement.