PL/SQL – Attribute to test not null and can take specific value instead

610 pts.
Tags:
NULL
Oracle development
Oracle PL/SQL
PL/SQL
PL/SQL procedure
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: