Re: Calculated columns
If you actually allocate space in the table, then it's not a proper 'calculated column', though the value in the field might be calculated. A calculated column is a one that only comes into being during a query, when you name the result of some calculation with an AS clause, such as SELECT count(*) AS number_in_the_db FROM tablename....
So, simply allocate the space during CREATE TABLE and structure your UPDATEs and INSERTs such that you do SET tst_Name="some name", tst_NameLength="9" etc.
I don't know why you'd want to save the string length, though.
Subject
Written By
Posted
February 12, 2005 07:28AM
Re: Calculated columns
February 12, 2005 02:44PM
February 13, 2005 07:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.