Home » SQL & PL/SQL » SQL & PL/SQL » Please resolve below SQL Query
Please resolve below SQL Query [message #435871] Fri, 18 December 2009 08:36 Go to next message
Messages: 1
Registered: December 2009
Location: India
Junior Member
Please resolve below SQL Query

there are three tables:

1) Trans - table 1

ProdCode number (FK)
Qty number
Value number
OrderNum number (FK)

2) Location - Table 2

Loc varchar
Loc_Desc varchar
OrderNum number (PK)

3) Product - Table 3

Prodcode number (PK)
Prod_Desc varchar

Print the output in following manner:

Prod_Code Prod_desc Loc_1(Qty, value) Loc_2(Qty, value) Loc_n(Qty_n, Value_n)......
Re: Please resolve below SQL Query [message #435872 is a reply to message #435871] Fri, 18 December 2009 08:37 Go to previous messageGo to next message
Messages: 25568
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: Please resolve below SQL Query [message #435875 is a reply to message #435871] Fri, 18 December 2009 08:42 Go to previous message
Michel Cadot
Messages: 65135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Standard "pivot" query we have each week, please search on the board.

With your question, you must post a test case, you must post your Oracle version and do many things explained in the link BlackSwan posted, please read and follow it, it is the Forum Guide.

Previous Topic: sql trace
Next Topic: Read a Comma separated Number String in Varchar2 field
Goto Forum:

Current Time: Wed Aug 16 22:59:46 CDT 2017

Total time taken to generate the page: 0.18316 seconds