Selecting null in the select list.

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. Received on Wed Dec 14 2005 - 17:15:07 CST