Re: Querying on Column Length

Learn the Oracle data dictionary. It contains the answer to just about any conceivable answer to any conceivable question ... well related to the database anyway. The basic data dictionary views come in three flavours user_, all_ and dba_. As a developer you will want to use the user_ (your objects) and all_ (all objects you can access) views. For what you want look at:

user_tab_columns
and
all_tab_columns

To learn more about the dictionary views run the following query:

SELECT *
FROM dict
WHERE table_name LIKE 'ALL%'
ORDER BY table_name;

Daniel Morgan

Kaitlin wrote:

> Hi,
>
> I am new to Oracle and could not find an answer to my question in the
> manuals. I need to find all rows in table A in which the length of
> column 1 is greater than char(20). Would any one know if this is
> possible and if so, what the correct syntax would be? Any help would
> be greatly appreciated. Thank you in advance.
>
> Kaitlin
Received on Mon Apr 01 2002 - 15:30:34 CST