Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Views question

Re: Views question

From: Robert Fazio <dbabob_at_yahoo.nospam.com>
Date: Wed, 15 Aug 2001 22:33:31 GMT
Message-ID: <Xns90FEBCB476C85dbabobyahoocom@24.12.106.199>


"Fayerman" <ilya_at_fayerman.org> wrote in
news:aHBe7.248$rw3.126752_at_dfiatx1-snr1.gtei.net:

>> By replacing the * with the current  column names.

> I need a dynamic view (select *) due to the changing structure of the
> tables. Specifying the current columns names would be the opposite of
> what I wanted.

What we are trying to tell you is that you can't do what you want. The closest think that you could do is setup a database trigger and watch for changes on that tables structure, then recreate the view.

-- 
Robert Fazio
Senior Technical Advisor
dbabob_at_yahoo.com
Received on Wed Aug 15 2001 - 17:33:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US