3 Replies Latest reply: Dec 28, 2012 12:30 AM by Jairam RSS

    how to rename column ?

    981979
      employee Table
      EMPNO   EMPNAME       JOB            SALARY   PLACE
      ----------- ----------------     ------            ------------  -------------
      1           san              employee       25000     africa
      
      2           tan              employee       30000     Africa
      
      3           pan              employee       35000     Africa
      
      4           sony            employee        40000     africa
      i want to rename EMPNAME as employeename,
      and EMPNO as employeenum

      the querry plz

      Thanks

      Edited by: 978976 on Dec 27, 2012 10:18 PM

      Edited by: 978976 on Dec 27, 2012 10:19 PM