On Mar 31, 7: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
Ramon,
Try looking at the user_tab_columns table to see the columns's
datatype, precision, etc.
Received on Mon Apr 02 2007 - 09:46:15 CDT
