Re: Generated by column syntax

On Aug 30, 8:24 am, "Shakespeare" <what..._at_xs4all.nl> wrote:
> "Brian Peasland" <d..._at_nospam.peasland.net> schreef in berichtnews:46d6d205$0$4367$88260bb3_at_free.teranews.com...
>
>
>
>
>
> > Jerry Alan Braga wrote:
> >> I have seen on some posts that you can do the following
>
> >> alter table test add col_3 generated always by (col_1 + col_2); --
> >> virtual col
>
> >> alter table test add col_3 generated by (col_1 + col_2); -- stored
> >> virtual col
>
> >> what is the syntax of the generated statement, where are the docs on this
>
> > This is a new 11g feature. Found at the following:
>
> >http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statem...
>

>
> Darn, missed that one. Time for an upgrade...
>
> Shamespeare

I work with an environment that has long emulated this functionality. Every so often I get burned as I write some SQL that requires these columns. The app doesn't always display them as being any different, so I have to compare SQL describes with the app, sometimes dozens of fields not necessarily in the same order. Virtual columns _are_ a very useful feature for enterprise apps.

It has slightly different limitations than the new Oracle functionality, so this should be interesting upgrading this app to 11g. I'm guessing it won't use the Oracle functionality for backward compatibility reasons, but I've been surprised before.

I wonder what changes Oracle will be making to FBI limitations?

jg

--
@home.com is bogus.
"Many of our customers are tourists from other countries.  We seem
especially popular with those from the UK, there's a bunch at the
counter now." - heard on radio, interview with Las Vegas company where
customers shoot fully automatic weapons such as AK-47s.