Home » Developer & Programmer » Forms » multipl rows into mutiple columns (Form 6i, oracle 10g)
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]

[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:
  


Current Time: Mon Jul 22 20:30:30 CDT 2024