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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following