Re: 30 character identifier size

Not sure whether tablename.columnname needs to be less than 30 chars... However, you could always use an ALIAS to get around this problem.

select very_long_table_name.very_long_col_name COL_ALIAS from very_long_table_name;

-sm

On Thu, 16 Oct 1997 20:27:10 -0700, MARI J MORTELL <mari.mortell_at_Sun.COM> wrote:

>Hello!
>Does anyone have a way around the 30 character limit on identifiers?
>30 wouldn't be too bad, except that the table_name.column_name together
>has to be less than 30 for an oci application.
>
>maybe V8 relaxes this?
>
>Thanks for your help!
>
>-Mari
Received on Fri Oct 17 1997 - 00:00:00 CEST