Larry Mulcahy

• Personal home page: http://www.nyx.net/~lmulcahy/

If you were to log in, you'd be able to get more information on your fellow community member.

Static Page Comments

• November 15, 1999, on Oracle 8 RDBMS Server:

  Re: How to rename a column in Oracle

  You can do something like the following, though I agree it shouldn't be necessary:

  SQL> describe phone_directory
   Name                            Null?    Type
   ------------------------------- -------- ----
   NAME                                     VARCHAR2(100)
   PHONE                                    VARCHAR2(100)
  
  SQL> create table new_phone_directory (full_name varchar(100), phone varchar(100));
  
  Table created.
  
  SQL> insert into new_phone_directory (full_name, phone)
    2  select name, phone from phone_directory;
  
  1 row created.
  
  SQL> commit;
  
  Commit complete.
  
  SQL> drop table phone_directory;
  
  Table dropped.
  
  SQL> rename new_phone_directory to phone_directory;
  
  Table renamed.