OraFAQ Forum: Client Tools » Check Null Value for SQL*PLUS Variable

Home » Other » Client Tools » Check Null Value for SQL*PLUS Variable

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Check Null Value for SQL*PLUS Variable [message #542655]

Wed, 08 February 2012 06:38

bholeuday
Messages: 28
Registered: April 2009
Location: Talavali

Junior Member

Hi,

In SQL*Plus i am accepting value like below examples

1] ACCEPT v_number prompt 'Enter Number ='

2] column db_owner new_value db_owner;

select a.SETTINGVALUE db_owner
from ABC a, DEF b
where a.application_id = b.application_id

I want to confirm after executing this .sql that this variables v_number and db_owner should not have NULL value. I did searched a lot for SQL*PLUS commands but didnt get any help on same. Only way i can check this is by writing anonymous PL/SQL block but i dont want to go for that option.
If anybody knows how to restrict input of NULL values then please reply back.

Thanks in advance Smile

Report message to a moderator

Re: Check Null Value for SQL*PLUS Variable [message #542657 is a reply to message #542655]

Wed, 08 February 2012 06:46

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I want to confirm after executing this .sql that this variables v_number and db_owner should not have NULL value

And what should be the result in each case?
Did you try a query against DUAL?

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle Practise at Solution Beacon
Next Topic:	Catch Oracle Login error in batch file.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 19 15:40:14 CST 2026