|
View previous topic :: View next topic
|
| Author |
Message |
prasanth_urs
New User
Joined: 04 Dec 2006
Posts: 44
Location: Pune,India
|
|
|
|
Hi all,
A requirement is as below.
Around 60 tables are inter related by foreign key.I want to join all the tables and extract all the columns of the table to a report.
could you please suggest the ways of doing the same?
the simple way to doing this by writing sql will fail when delimiting the fields.
what all will be the other ways?
Thanks
Prasanth |
|
| Back to top |
|
 |
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| prasanth_urs wrote: |
tables and extract all the columns of the table to a report.
the simple way to doing this by writing sql will fail when delimiting the fields.
|
What kind of a report has delimited fields? Perhaps you mean file instead of report. |
|
| Back to top |
|
|
prasanth_urs
New User
Joined: 04 Dec 2006
Posts: 44
Location: Pune,India
|
|
|
|
| yes, i require the file delimited by any special character and then export it to a spreadsheet. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Quote: |
by writing sql will fail when delimiting the fields.
|
you mean by either an sql with select col1, ';',col2,';'....
or an unload with sql that has field/column separater.
i have shown you how to do it with select column, literal, ....
there are many examples in the forum for unloads,
as well as the manuals. |
|
| Back to top |
|
|
prasanth_thavva
New User
Joined: 28 Jul 2005
Posts: 86
Location: Chennai
|
|
| Back to top |
|
|
|
|
