Home » SQL & PL/SQL » SQL & PL/SQL » Deleting A Column
Deleting A Column [message #2921] Thu, 22 August 2002 04:43 Go to next message
Gregg
Messages: 7
Registered: August 2002
Junior Member
Using Oracle 7.3.4, is it possible to delete a entire column. We are no longer using the column so I would like to get rid of it.

Thanks
Re: Deleting A Column [message #2922 is a reply to message #2921] Thu, 22 August 2002 04:53 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
not possible to delete a column with 7.x
it availble only with 8 and above.
workaround is to create a new table without that unwanted column

create table new_table
as
(select c1,c2,c4,c5 from old_table);

-- check whether data is OK in new_table.
-- drop old_table.
-- rename new table to Old_table.

Previous Topic: UTL File
Next Topic: URGENT!! Lenght of the data
Goto Forum:
  


Current Time: Thu Mar 28 05:43:21 CDT 2024