SQL>
SQL> CREATE TABLE emp (
2 empID INT NOT NULL PRIMARY KEY,
3 Name VARCHAR(50) NOT NULL);
Table created.
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
2 SUBSTR(Name, INSTR(Name, ' ') + 1) || ', ' ||
3 SUBSTR(Name, 1, INSTR(Name, ' ') - 1) AS empName
4 FROM emp
5 ORDER BY empName;
EMPNAME
--------------------------------------------------------------------------------
Bill,
Cat,
Jack,
Mary,
Tom,
Victor,
6 rows selected.
SQL>
SQL> drop table emp;
Table dropped.