Re: Oracle 11g Virtual Columns?

From: hpuxrac <>
Date: Sun, 18 Jan 2009 15:34:34 -0800 (PST)
Message-ID: <>

On Jan 18, 5:26 pm, 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 of course triggers are evil but views can also serve the same purpose.

As I remember Tom Kyte was excited about the virtual columns so there must be some benefits.

I guess one way is to have a virtual column and be able to build an index on it. Received on Sun Jan 18 2009 - 17:34:34 CST

Original text of this message