BCFD36 wrote:
This should be simple. Either it can't be done, I'm using the wrong
syntax, or using the wrong approach.
I'm running a perl script that queries the db, and gets back an
answer. That works just fine. However, on occasion one of the returned
values is null since it is null in the data base. I tried sending a
"set null null" the same way I sent the select command, but it
generated an error:"missing or invalid option. Were I directly in
sqlplus, I could say "set null null" and a string with "null" in it
would be returned.
Any suggestions?
D. Scruggs
Lockhkeed Martin, Sunnyvale Ca.
The command "SET" is a builtin command of sqlplus, not a valid SQL
command. Thus the database does not understand it. You eiher could use
the SQL-function NVL to circumvent NULLs or check within Perl with
'defined'.
HTH
Hannes
--
Johannes Gritsch
www.linuxification.at
