|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
June 20th, 2004, 12:38 AM
|
|||
|
|||
|
Text File generation in Report 6i
I am using Oracle Report 6i.
Can anybody say how to generate a text file with Zero spacing between fields. if the field output are 1234 Man Sre then the report output shoud be a text file 1234ManSre
|
|
#2
June 29th, 2004, 03:25 PM
|
|||
|
|||
|
Probably complety missing the point of your question, but...
SELECT REPLACE(item1||item2||item3, ' ') AS output_string FROM table will collapse the string removing all spaces
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Text File generation in Report 6i |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
