OraFAQ Forum: Forms » multipl rows into mutiple columns

Home » Developer & Programmer » Forms » multipl rows into mutiple columns (Form 6i, oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

multipl rows into mutiple columns [message #689897]

Sun, 30 June 2024 09:05

shahzad-ul-hasan
Messages: 617
Registered: August 2002

Senior Member

Form 6i, oracle 10g
Dear i have two Tables.

Table -1
pid   Number(6)
odate date
dsno  number(3)
did   number(5)
Det   Varchar2(50)
qty   Number(7)
Rat   Number(5)

Table-2
pid   Number(6)
tdate date
t     number(7)
t1    number(7)
t2    number(7) 
t3    number(7)
t4    number(7)
t5    number(7)
t6    number(7)
t7    number(7)
.
please see the attached file. i want to convert multiple rows into multiple column in one rowgainst one pid(party id).please help me.[img]/forum/fa/14795/0/[/img]

Attachment: ows into coulmn.jpg
(Size: 203.65KB, Downloaded 43 times)

[Updated on: Sun, 30 June 2024 09:06]

Report message to a moderator

Previous Topic:	How to create menu using database table (2 topics merged, duplicate deleted, moved to Forms by bb)
Next Topic:	When_validate_item trigger not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 16:32:11 CDT 2024