Using Aliases
SQL> SQL> CREATE TABLE emp ( 2 empID INT NOT NULL PRIMARY KEY, 3 Name VARCHAR(50) NOT NULL); Table created. SQL> SQL> INSERT INTO emp (empID,Name) VALUES (1,'Tom'); 1 row created. SQL> INSERT INTO emp (empID,Name) VALUES (2,'Jack'); 1 row created. SQL> INSERT INTO emp (empID,Name) VALUES (3,'Mary'); 1 row created. SQL> INSERT INTO emp (empID,Name) VALUES (4,'Bill'); 1 row created. SQL> INSERT INTO emp (empID,Name) VALUES (5,'Cat'); 1 row created. SQL> INSERT INTO emp (empID,Name) VALUES (6,'Victor'); 1 row created. SQL> SQL> SELECT Name AS empName, empID AS ID FROM emp; EMPNAME ID -------------------------------------------------- ---------- Tom 1 Jack 2 Mary 3 Bill 4 Cat 5 Victor 6 6 rows selected. SQL> SQL> drop table emp; Table dropped.