Column data need to be retreived in Row format

[anuj]

Hi All,

Mt Data is in this Format:

Table A:

Instr_id
--------
157
158
159

Table B:

Instr_id---id_ctxt_typ---iss_id
-------------------------------
157 NASDAQ 123
157 CUSIP 456
157 COMPANY 789

I need to get data in this format by using these two tables:

Instr_id NASDAQ CUSIP COMPANY
--------------------------------
157 123 456 789
158 zzz yyy xxx

How can I generate a sql which gives this type of format data.

Thanks&Regards,
Anuj

[DaPi]

Search for "pivot" here: http://asktom.oracle.com/