checking contents of a variable [message #37782] |
Thu, 28 February 2002 01:46 |
MarcoC
Messages: 10 Registered: February 2002
|
Junior Member |
|
|
hi all,
I need to check if a variable holds only values contained in a string. i.e. '.ABCDEFGHILMNOPQRSTUVZ'.
What would it be the best way to achieve this?
Is there any built-in SQL function returning a boolean?
Thanks Marco
|
|
|
|
Re: checking contents of a variable [message #37799 is a reply to message #37782] |
Thu, 28 February 2002 07:26 |
MarcoC
Messages: 10 Registered: February 2002
|
Junior Member |
|
|
Hi,
select nvl(translate(:v_user_subpgm,'._ABCDEFGHILMNOPQRSTUVZ1234567890',' '),'NULL')
from dual
why I get result equal to ' ' when I set v_user_subpgm to 'SCAN_SUBPGM' but I get 'NULL' when I set it to 'FORMAZIONE.SCAN_SUBPGM'? Thanks,
Marco
|
|
|
|