Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
forevercalz
Starting Member
5 Posts |
 Posted - 2005-12-02 : 00:27:02
|
| i have this script here..text=/d:/...../1.txt..................................................................spool $text;selectitem || '|' ||ord_no || '|' ||price || '|' ||from order_tableThe output header of this spooled data will be item||'|'||ord_no||'|'||price||'|'|--------------------------------F42777|073059|100|However now i want the header to be like this and the output remains the same....is there a way to do it?item|ord_no|price|--------------------------------F42777|073059|100|thanks for great help! |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-12-02 : 00:32:31
|
| I think u are working on Oracle. Post this in Oracle Forum. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-02 : 00:33:08
|
| Oracle? If so probably no one here who can give you much help.If not then I clearly didn't understand the question!Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-02 : 01:55:32
|
| I think you can use alias name for the columnsBut better post this question at Oracle Forum www.DBforums.comMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
help with sql header