Re: Generated by column syntax

"Brian Peasland" <dba_at_nospam.peasland.net> schreef in bericht news: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/statements_3001.htm#CJAHHIBI
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account from http://www.teranews.com
>

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

Shamespeare Received on Thu Aug 30 2007 - 10:24:21 CDT