Hi Everybody,

Is there any thing called pivot tables in oracle.

I am having a problem...

i have created a table
SQL>create table acc1(accid number(5),
cr_dr varchar2(3),amount number(7,2));

Table created.

THEN I INSERTED SOME VALUES IN THAT TABLE

SQL> insert into ACC1 values(1,'CR',100);

1 row created.

SQL> insert into ACC1 values(1,'DR',200);

1 row created.

SQL> SELECT * FROM ACC1;

ACCID CR_ AMOUNT
---------- --- ----------
1 CR 100
1 DR 200

Now my prob is i want output like

ACCID CR DR
--------- ------- -------
1 100 200

If any body have any idea pls help

Thanks in advance
pras