ERPstuff - Oracle EBS Community

Hi master

I hope you are good and comfort
Sir my problem is
I have log query from many table now my need is query display result separately
Such as

Query
Select a.name,a.fanem,a.address,a.phone,b.carbillno,b.carbillamount,c.homelona,c.loaninst,d.chqno,d.chqamount from a,b,c,d where a.no=b.no and a.no=c.no and b.no=d.no

Result need is following format

Data from table a
?????
??????
????
Data from table b
?????
??????
????

Data from table c
?????
??????
????

Data from table d
?????
??????
????

Please give me idea how I get this type of result

Thanks

aamir

Pl let us know what is the objective you want to get out of it. So may be someone can give a better idea to do that. As from this I don't know what you want to achieve. thanks

You want it in a report or a Sql Plsql


Cheers
Najm

Najm

on Sql Prompt u Can Do this By Using Prompt Command