Home » SQL & PL/SQL » SQL & PL/SQL » Selecting rows with NULLand BLANK values
Selecting rows with NULLand BLANK values [message #37709] Fri, 22 February 2002 07:42 Go to next message
ron
Messages: 50
Registered: July 1999
Member
Hi,
I have two columns OLD and NEW in a table.

for few rows I have either NULLS or BLANKS values in OLD column, but in NEW there are values.

my function takes values from OLD as parameter and converts them into values (that are in NEW column).
it works for all values of OLD column except NULL and ''(BLANKs), which have corresponding values in NEW column. please advice me how to handle this.

Thanks
Re: Selecting rows with NULLand BLANK values [message #37710 is a reply to message #37709] Fri, 22 February 2002 08:30 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
I'm not certain I understand your question.

Does NVL(OLD, NEW) work? If not, please add some detail and I'll try to help.
Previous Topic: Rollback & ROWID
Next Topic: modify constraint for on cascade delete
Goto Forum:
  


Current Time: Thu Mar 28 04:13:04 CDT 2024