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
>
There are demos of Virtual column creation and usage in Morgan's Library
at www.psoug.org under VIRTUAL COLUMNS.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Sep 04 2007 - 11:21:55 CDT
