Re: identifying variable declaration within PL/SQL
From: Michael Myers <mjmyers_at_nospam.blazenet.net>
Date: Wed, 31 Mar 1999 21:44:08 -0500
Message-ID: <3702DD78.CEB6A400_at_nospam.blazenet.net>
Date: Wed, 31 Mar 1999 21:44:08 -0500
Message-ID: <3702DD78.CEB6A400_at_nospam.blazenet.net>
> This means that I can't use it in straight old PL/SQL.
> Furthermore, the functioselect table_name from all_tables where table_name like 'n only returns the actual number of bytes used
> in storage -- it does not return the declared length.
You could try the dictionary. Query table_name, column_name, data_type, and data_length from ALL_TAB_COLUMNS, DBA_TAB_COLUMNS, or USER_TAB_COLUMNS Received on Thu Apr 01 1999 - 04:44:08 CEST