Re: Generated by column syntax

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