Re: Selecting null in the select list.

On 14 Dec 2005 15:15:07 -0800, "DaLoverhino" <DaLoveRhino_at_hotmail.com> wrote:

>Suppose I have a sql statement like so:
>
>select kind, amount from petstore;
>
>
>Now, I want to change it so that amount is always null. I want to do
>this, because we have some C++ code that assumes a fixed number of
>fields returned (for this example, it's 2).
>
>
>Is it possible to do the following:
>
>select kind, null from petstore;
>
>It appears to work fine from the sqlplus prompt. But, I'm wondering if
>this will trip up any OCCI/OCI libraries?
>
>
>thanks.

Provided you use NULL indicator variables on the affected columns: NO

--
Sybrand Bakker, Senior Oracle DBA