Home » SQL & PL/SQL » SQL & PL/SQL » how is it possible??? (Column In Rows) (Oracle 9i,10g)
how is it possible??? (Column In Rows) [message #391758] Fri, 13 March 2009 06:12 Go to next message
mamalik
Messages: 266
Registered: November 2008
Location: Pakistan
Senior Member

Dear All Experts.

I have follwoing table.
create table orafaq(
vch_cod number,
bch_num number,
opn_bgs number);
insert into orafaq values(1,51469,10);
insert into orafaq values(2,53469,20);
insert into orafaq values(1,77814,20);
insert into orafaq values(1,53469,10);
select * from orafaq
it contains data like
VCH_COD	BCH_NUM	OPN_BGS
1	51469	10
2	53469	10
1	77814	20
1	53469	20


Now i want to display data like this. Vch_cod 1 mean Receipt 2 mean Issue

Batch No    Receipt       Issue
51469        10
53469        20            10
77814        20


How can we do this.

Best Regards.
Asif.
Re: how is it possible??? (Column In Rows) [message #391761 is a reply to message #391758] Fri, 13 March 2009 06:45 Go to previous message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Search for the term 'PIVOT'
Previous Topic: NUMBER with One precision
Next Topic: Encountered the symbol "(" (merged 3)
Goto Forum:
  


Current Time: Fri Dec 09 23:00:41 CST 2016

Total time taken to generate the page: 0.09208 seconds