Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Modify Table Insert Calculated Column

Modify Table Insert Calculated Column

From: <biggs_at_trilliant.com>
Date: 21 Apr 2006 10:02:06 -0700
Message-ID: <1145638926.331684.106810@t31g2000cwb.googlegroups.com>


Please tell me the syntax for inserting a calculated column into an Oracle 10g database. The SQL Server ALTER TABLE code won't work. A simple example:

ALTER TABLE Rentals

     ADD TotalRentals AS TotalRentals + RentalQuantity;

I've spent a couple hours searching the doc & Google and I'm coming up emty handed. This should be simple!

Thanks Received on Fri Apr 21 2006 - 12:02:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US