Re: How to do the equivalent of 'describe' with a SELECT?

On Mar 31, 9:50 am, "Ramon F Herrera" <r..._at_conexus.net> wrote:
> The SQL code that I need is for a Pro*C/C++ application. Before my
> compiled C program does its main thing, it should check the current
> sizes of the variables in the target table.
>
> I would like to be able to change the variables' sizes, for instance,
> from:
>
> VARCHAR(20);
>
> to
>
> VARCHAR(30);
>
> without having to recompile all my C programs. Or at least, reduce the
> impact of such resize.
>
> TIA,
>
> -Ramon

Dear Self:

The OCI Demo programs include one, aptly called 'descr.c', which does what you asked for.

-Ramon Received on Sun Apr 01 2007 - 15:59:26 CDT