January 26th, 2005, 03:10 AM
|
|
Registered User
|
|
Join Date: Jan 2005
Posts: 14
Time spent in forums: 1 m 25 sec
Reputation Power: 0
|
|
Problem using NVL Function
I ran across a problem with the format of an ASCI output file of an SQL script. The problem I have is with handling a particular column that contains account numbers. The column is defined with 8 characters. However not every entry has data. I have several fields that don't have any information.
Originally in my script I had the following line that made the script fail:
Code:
LPAD(TO_CHAR(TO_NUMBER(konten_nr)),8,'0'),
I then changed the line to the following: (The script ran but now I notice that the formatting is wrong)
Code:
LPAD(TO_NUMBER(LTRIM(konten_nr)),8,'0'),
I attempted to use the NVL function that will return a value when there is nothing in the column field but it doesn't work. Does anyone know what I'm doing wrong?
Code:
LPAD(NVL(TO_CHAR(TO_NUMBER(konten_nr),'FM999999999'),'0'),8,'0'),
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
