Home » SQL & PL/SQL » SQL & PL/SQL » rows into a fix no. of columns of in a raw
rows into a fix no. of columns of in a raw [message #18847] Mon, 18 February 2002 20:18 Go to next message
krahuman
Messages: 18
Registered: January 2002
Junior Member
this my problem
i want to generate the following format for a report

records in the table

category account
c1 a1
c1 a2
.. ..
.. ..
c2 b1
c2 b2
c3 b3

----------

the report fomat should be

c1 a1,a2,a3
c1 a4,a5

c2 b1,b2,b3
c2 b4,b5,b6
c2 b7,b8

how can i generate this format using sql/plsql block in ora 8i?
kaleel
Re: rows into a fix no. of columns of in a raw [message #18851 is a reply to message #18847] Tue, 19 February 2002 00:22 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

it is better idea to write pl/sql to achieve this.try writing it , if u find any difficulty then give more data and required output. The data and output , you have provided is not clear.

cheers
pratap
Previous Topic: Tool to convert MS-Access-SQL to Oracle-SQL
Next Topic: log on (problem) HELP
Goto Forum:
  


Current Time: Fri Mar 29 05:42:41 CDT 2024