Re: Oracle 11g Virtual Columns?

On Jan 19, 11:20 pm, Connor McDonald <connor_mcdon..._at_yahoo.com>
wrote:
> zigzag..._at_yahoo.com wrote:>> > I have read various articles on virtual columns? I still do not> > understand their advantages other than they save some disk space, One> > can put logic of virtual columns in a trigger which will save> > information in a real column. Real column will need some additional> > disk space, but it will save some cpu time when one is doing slelects> > on “virtual” columns.>> Well, they're columns...so lots of goodies just in that, eg constraints> (foreign key, not null, unique, primary key), optimizer stats, fgac, etc> etc

... and don't forget you can partition based on virtual columns -
could be very handy.