Returning null from query

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.

• Returning null from query by BCFD36
• Re: Returning null from query by Johannes Gritsch
• Re: Returning null from query by pgodfrin