How to create computed field/column in a table

Hi

Does anyone know how create a computed column in a table?

In MS SQL Server you do it like this:

CREATE TABLE mytable (
  key numeric not null primary key,
  value1 numeric not null,
  value2 numeric not null,
  value3 as (value1*value2)
)

How is it done in Oracle?

Gr.

Jesper Received on Tue Nov 20 2001 - 02:44:42 CST