Home » SQL & PL/SQL » Client Tools » Check Null Value for SQL*PLUS Variable
Check Null Value for SQL*PLUS Variable [message #542655] Wed, 08 February 2012 06:38 Go to next message
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
Re: Check Null Value for SQL*PLUS Variable [message #542657 is a reply to message #542655] Wed, 08 February 2012 06:46 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Oracle Practise at Solution Beacon
Next Topic: Catch Oracle Login error in batch file.
Goto Forum:
  


Current Time: Sat Aug 30 14:08:33 CDT 2014

Total time taken to generate the page: 0.08101 seconds