Re: Generated by column syntax

From: Jerry Alan Braga <jerry.braga_at_hotmail.com>
Date: Thu, 30 Aug 2007 14:36:26 GMT
Message-ID: <KBABi.16778$vP5.12746@edtnps90>

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

<fitzjarrell_at_cox.net> wrote in message
news:1188480358.787976.242160_at_22g2000hsm.googlegroups.com...
> On Aug 30, 7:13 am, "Jerry Alan Braga" <jerry.br..._at_hotmail.com>
> wrote:
>> does anyone have any references to this and what are the capabilities
>
> Do you have a better explanation of what you want?
>
>
> David Fitzjarrell
>
Received on Thu Aug 30 2007 - 09:36:26 CDT