Getting contents of view by SQL

#1

I recall that it was possible somehow.... that one could read out the
content of a view with a (simple) sql sentence

can anyone specify?

I use oracle 9

WBR
Sonnich

#2

"jodleren" <sonnich (AT) hot (DOT) ee> wrote

Quote:

I recall that it was possible somehow.... that one could read out the
content of a view with a (simple) sql sentence

can anyone specify?

I use oracle 9

WBR
Sonnich

Take a look at ALL_VIEWS.

Terry Dykstra

#3

On Apr 17, 5:44*pm, "Terry Dykstra" <tddyks... (AT) forestoil (DOT) ca> wrote:

Quote:

"jodleren" <sonn... (AT) hot (DOT) ee> wrote in message

news:0373e17e-a5d0-42f8-a3f9-8732c00746c3 (AT) l1g2000yqk (DOT) 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

#4

On Apr 17, 2:14*pm, jodleren <sonn... (AT) hot (DOT) ee> wrote:

Quote:

I recall that it was possible somehow.... that one could read out the
content of a view with a (simple) sql sentence

can anyone specify?

I use oracle 9

WBR
Sonnich

It's worth looking at the DICTIONARY or DICT_COLUMNS views for clues
about where things are in the data dictionary.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Getting contents of view by SQL

comp.databases.oracle.misc comp.databases.oracle.misc

Getting contents of view by SQL - 04-17-2009 , 08:14 AM

Re: Getting contents of view by SQL - 04-17-2009 , 09:44 AM

Re: Getting contents of view by SQL - 04-17-2009 , 10:33 AM

Re: Getting contents of view by SQL - 04-18-2009 , 06:49 AM