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 -> Re: Removing columns from a table

Re: Removing columns from a table

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 20 Jun 1999 21:30:00 +0800
Message-ID: <376CECD8.A40@yahoo.com>


John Harris wrote:
>
> Is it possible to remove tables from an oracle table? If so, how is it
> done? Thank you.
>
> John Harris
> University of Utah

Supported in 8i...before this, the easiest way is to rename the table and then create a view with the original name minus the offending column

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Jun 20 1999 - 08:30:00 CDT

Original text of this message

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