Although good general advice, I'm not sure that is a relevant
response to the original poster.
What the poster wanted was the rows having a value of length greater
than 20 in a particular column. What she needs is to use '...where
length(column) > 20;
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 1 Apr 2002, damorgan wrote:
> 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;
>
> Kaitlin wrote:
>
> > 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.
Received on Mon Apr 01 2002 - 16:44:48 CST
