4 Replies Latest reply: Jul 8, 2010 8:02 AM by 783647 RSS

    Computed by column

      In the article below I found some informations about computed columns. This article tell that this feature is avaliable since version 7.1. Someone could tell me in which version this feature (computed columns) was introduced?


      Edited by: user13372970 on 07/07/2010 12:03
        • 1. Re: Computed by column
          Tim Boles
          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
          • 2. Re: Computed by column
            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.

            Sybrand Bakker
            Senior Oracle DBA
            • 3. Re: Computed by column
              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
              • 4. Re: Computed by column