Re: Getting contents of view by SQL

From: jodleren <sonnich_at_hot.ee>
Date: Fri, 17 Apr 2009 08:33:53 -0700 (PDT)
Message-ID: <278e60b3-17b1-4835-b6ac-e9a0658bd3d2_at_c12g2000yqc.googlegroups.com>

On Apr 17, 5:44 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> "jodleren" <sonn..._at_hot.ee> wrote in message
>
> news:0373e17e-a5d0-42f8-a3f9-8732c00746c3_at_l1g2000yqk.googlegroups.com...
>
> >I recall that it was possible somehow.... that one could read out the
> > content of aviewwith a (simple)sqlsentence
>
> > can anyone specify?
>
> > I use oracle 9
>
> > WBR
> > Sonnich
>
> Take a look at ALL_VIEWS.
>
> Terry Dykstra

Thanks, that worked

select * from ALL_VIEWS where view_name like 'PTL%'

WBR
Sonnich Received on Fri Apr 17 2009 - 10:33:53 CDT