CREATE TABLE EMP (EMP_CODE VARCHAR2(12),EMP_NAME VARCHAR2(20),SAL NUMBER);

INSERT INTO EMP VALUES ('1','A',10);

INSERT INTO EMP VALUES ('2','C',3);

INSERT INTO EMP VALUES ('3','B',20);

SELECT * FROM EMP ORDER BY EMP_CODE;

SELECT * FROM EMP ORDER BY EMP_NAME;

SELECT * FROM EMP ORDER BY SAL;

--note order by is changing, how its doable in report 6i.