-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|