Re: Newbie oracle questions

Tyler Schoenke (schoenke_at_mfa.com) wrote:
: 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?

No.

: Is there a way to rename columns without dropping a table?

No. You can use views though, to "rename" columns.

: Is there a FAQ for this group?

URL: http://www.bf.rmit.edu.au/Oracle/contents.html

: 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?

A table can always be renamed to another non-existent object, regardless of existence of data.
: Thanks,
: --
: Tyler Schoenke McHugh Freeman - Software Engineer (414)798-8600

--
---------------------------------------------------------------------------
Kannan 
Email: skannan_at_fs.com
Mastech Systems Corporation

The above are my own comments and opinion. They do not purport that of 
anybody else.
---------------------------------------------------------------------------