Select Query Oracle PLSQL

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.