Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Chennai, India
    Posts
    3

    Unanswered: can I CHANGE THE COLUMN NAME IN ORACLE

    Table Name : EMP

    Structure:

    ID NUMBER(5);
    ENAME VARCHAR2(50);



    Is it possible to change the column name ENAME as EmployeeName.

    thanx in advance

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: can I CHANGE THE COLUMN NAME IN ORACLE

    If Oracle 9, you do this:

    alter table mytable rename oldcol ttt to newcol




    Originally posted by haisharan
    Table Name : EMP

    Structure:

    ID NUMBER(5);
    ENAME VARCHAR2(50);



    Is it possible to change the column name ENAME as EmployeeName.

    thanx in advance

  3. #3
    Join Date
    Jan 2004
    Location
    Chennai, India
    Posts
    3

    Re: can I CHANGE THE COLUMN NAME IN ORACLE

    Originally posted by ndu35
    If Oracle 9, you do this:

    alter table mytable rename oldcol ttt to newcol
    Thanx.

    ALTER TABLE emp RENAME COLUMN ename TO EmployeeName

    ya its Work in Oracle 9

    Thanx indeed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •