PL/SQL – Attribute to test not null and can take specific value instead
Hi Experts,
How can we make a check on an attribute not null but can take - rather
I have address 3 which can't take null instead - would be fine
how this can be check n PL/SQL procedure
Software/Hardware used:
Software/Hardware used:
ASKED:
February 9, 2009 11:13 AM
UPDATED:
February 9, 2009 3:31 PM
RELATED QUESTIONS
Answer Wiki:
I'm not sure if I understand correctly your question.
If you want to assign some specific value to a varibale or parameter in PL/SQL when it is null, you could use the NVL function, this way:
<pre>l_variable := nvl(l_variable,'-');</pre>
If this is not what you meant, please provide more information and examples if possible.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
