Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Querying on Column Length
On re-reading the question I believe you are correct.
Daniel Morgan
Jeremiah Wilton wrote:
> 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 - 17:31:46 CST
![]() |
![]() |