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
Messages: 50
Registered: July 1999
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.

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
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: Fri Sep 24 04:48:47 CDT 2021