Subject Computed Fields
Author Martin D. Berezaga
What should be a real life usage of COMPUTED columns?

In the case of some like:
CREATE TABLE EMPLOYEE
(FIRST_NAME VARCHAR(10) NOT NULL,
LAST_NAME VARCHAR(15) NOT NULL,
FULL_NAME COMPUTED BY (LAST_NAME || ', ' || FIRST_NAME));

To get the full name, I'd use the expression LAST_NAME ||
', ' || FIRST_NAME in a SELECT clause.

Is there a performance or some other kind of motivation to use COMPUTED
columns?

Thanks.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------

_______________________________________________________________________
Yahoo! PageBuilder
O super editor para criação de sites: é grátis, fácil e rápido.
http://br.geocities.yahoo.com/v/pb.html