This content has been marked as final. Show 4 replies
Curious....is this for a trivia game or something?
I think that you are miss reading the article.
The special "Computed Columns" were first available in 7.1 called automatic columns.
However, being able to do computations on columns has been around since Oracle was first introduced.
Edited by: Tim Boles on Jul 7, 2010 12:16 PM
Just for your information:
Oracle RdB is an acquired product, formerly Dec Rdb.
As such it is a completely different product from Oracle Rdbms, and as you are referring to Rdb 7.1, not Oracle 7.1, I'm wondering what your question is doing here.
Virtual columns where introduced in Oracle in 11g.
Senior Oracle DBA
Thanks for the answers, I wasn't aware of the difference between Oracle Rdb and Oracle Rdbms.
I think they address my further questions:
1) I'm using Oracle 10g, and I wasn't able to run any examples on automatic columns. My first question was misleading from the start.
2) I'm wondering about a similar feature to virtual columns in 11g in earlier versions, without using triggers.
Sorry if it's posted in the wrong place.
Edited by: user13372970 on 07/07/2010 12:43