Re: How to delete a column from a table?

Simon Goland wrote:
>
> Yes, I know, I have seen it here sometime ago. But it was "then", and I
> thought I won't need it... but now I do... ;-)
>
> So my long and tedious approach so far is:
>
> --
> [ Simon Goland B-)> sg_at_mda.ca ]
> [ Without action there is no change ]

Cheap and easy way...but not really doing the drop...

rename table xxx to xxx_gone
create view xxx as select (* minus missing column) from xxx_gone...

Voila ! (Ugh...)

Cheers

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin