|
-
There is no command to drop columns until Oracle 8.1.
The best way to do this in ver 7 - 8 is probably to rename the existing table. Then re-create the table looking the way you want followed by inserting the data using an insert as select statement.
create table NEW_TABLE (column name datatype) AS SELECT * FROM THE OLD_TABLE.
vidhya
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote