Re: ** SQL Query Ouput Format **

From: <parag9i_at_gmail.com>
Date: 10 Jun 2005 07:46:08 -0700
Message-ID: <1118414768.075134.60130@g47g2000cwa.googlegroups.com>

Hi Mark/Sybrand,

My SQL version in Oracle9iR2. I think I know how to write SQL to extract the data. But I want ouput in exactly in same way I have mentioned it thru SQL.

I do not have any idea of generating this file record type output thru SQL. I though I may use chr(10) ( new line ) with '||' but did not find practical. This report can be generated by other way like Report Builder, Business Objects ..etc but I want to generate data in SQL. Actually I want to generate this data for Bank for clients, accounts, faciliites ...etc. I have put my requirement thru Dept,emp example.

looking for your answer.

regards
pjp Received on Fri Jun 10 2005 - 09:46:08 CDT