Newbie oracle questions
From: Tyler Schoenke <schoenke_at_mfa.com>
Date: 1995/08/23
Message-ID: <41g9n7$eip_at_homer.alpha.net>#1/1
Date: 1995/08/23
Message-ID: <41g9n7$eip_at_homer.alpha.net>#1/1
I just started using Oracle a few months ago, and am getting into modifying tables. I have some questions on features that I haven't been able to locate.
Is there a way to delete columns without dropping a table?
Is there a way to rename columns without dropping a table?
Is there a FAQ for this group?
When doing major reconstruction to a table, what is the best way to move data out? I figured that one could create a new table, do a insert/select combination to pull the data out of the old table, into the new. If this would work, can you rename a table once it has been created?
Thanks,
-- Tyler Schoenke McHugh Freeman - Software Engineer (414)798-8600Received on Wed Aug 23 1995 - 00:00:00 CEST