(SELECT 
idp055.ROWID,
IDP010.AYBLNO 
FROM 
IDP055 ,
IDP010 ,
IDP050
WHERE 
IDP055.EYBLNO = IDP010.AYBLNO AND
IDP010.AYBLNO = IDP050.BYBLNO
GROUP BY IDP055.ROWID,IDP010.AYBLNO) 
MINUS
(SELECT 
idp055.ROWID,
IDP010.AYBLNO 
FROM 
IDP055 ,
IDP010 ,
IDP050
WHERE 
IDP055.EYBLNO = IDP010.AYBLNO AND
IDP010.AYBLNO = IDP050.BYBLNO AND
ROWNUM<=3
GROUP BY IDP055.ROWID, IDP010.AYBLNO )
ORDER BY 1 

SQL> select rowid,ENAME from emp where DEPTNO=20;

ROWID              ENAME
------------------ ----------
AAAyd2AAHAAAAoeAAA SMITH
AAAyd2AAHAAAAoeAAD JONES
AAAyd2AAHAAAAoeAAH SCOTT
AAAyd2AAHAAAAoeAAK ADAMS
AAAyd2AAHAAAAoeAAM FORD


SQL> select rowid,ENAME from emp where DEPTNO=20
  2    minus
  3    select   rowid,ENAME from emp where DEPTNO=10;

ROWID              ENAME
------------------ ----------
AAAyd2AAHAAAAoeAAA SMITH
AAAyd2AAHAAAAoeAAD JONES
AAAyd2AAHAAAAoeAAH SCOTT
AAAyd2AAHAAAAoeAAK ADAMS
AAAyd2AAHAAAAoeAAM FORD

SQL> select ENAME,rowid from emp where DEPTNO=20
  2    minus
  3    select ENAME,rowid from emp where DEPTNO=10;

ENAME      ROWID
---------- ------------------
ADAMS      AAAyd2AAHAAAAoeAAK
FORD       AAAyd2AAHAAAAoeAAM
JONES      AAAyd2AAHAAAAoeAAD
SCOTT      AAAyd2AAHAAAAoeAAH
SMITH      AAAyd2AAHAAAAoeAAA

SQL>

WITH t AS (SELECT 1 x FROM dual
            UNION ALL
           SELECT 1 x FROM dual
           UNION ALL
           SELECT 1 x FROM dual
           UNION ALL 
           SELECT 2 x FROM dual
           UNION ALL 
           SELECT 3 x FROM dual
           UNION ALL 
           SELECT 4 x FROM dual)
,
    y as (SELECT 2 b FROM dual 
           UNION ALL 
          SELECT 4 FROM dual)
SELECT x FROM t
MINUS
SELECT b FROM y;
X                      
---------------------- 
1                      
3                      

2 rows selected

SQL> select JOB,EMPNO from emp;

JOB            EMPNO
--------- ----------
SALESMAN        7369
SALESMAN        7499
SALESMAN        7521
MANAGER         7566
SALESMAN        7654
MANAGER         7698
MANAGER         7782
ANALYST         7788
PRESIDENT       7839
SALESMAN        7844
CLERK           7876
CLERK           7900
ANALYST         7902
CLERK           7934
CLERK           2000

15 rows selected.

SQL> select JOB,EMPNO from emp
  2  MINUS
  3  select NULL,NULL from DUAL;

JOB            EMPNO
--------- ----------
ANALYST         7788
ANALYST         7902
CLERK           2000
CLERK           7876
CLERK           7900
CLERK           7934
MANAGER         7566
MANAGER         7698
MANAGER         7782
PRESIDENT       7839
SALESMAN        7369
SALESMAN        7499
SALESMAN        7521
SALESMAN        7654
SALESMAN        7844

15 rows selected.

SQL>

SQL> with data as 
  2    ( select 'éa' from dual union all select 'eb' from dual )
  3  select * from data
  4  minus
  5  select null from dual
  6  /
'É
--
eb
éa

SQL> with data as 
  2    ( select 'éa' from dual union all select 'eb' from dual )
  3  select * from data
  4  order by 1
  5  /
'É
--
éa
eb

SQL> CREATE TABLE test_ord (col VARCHAR2(10));

Table created.

SQL> INSERT INTO test_ord
  2              (col
  3              )
  4       VALUES ('121'
  5              );

1 row created.

SQL> INSERT INTO test_ord
  2              (col
  3              )
  4       VALUES ('0123'
  5              );

1 row created.

SQL> INSERT INTO test_ord
  2              (col
  3              )
  4       VALUES ('0111'
  5              );

1 row created.

SQL> INSERT INTO test_ord
  2              (col
  3              )
  4       VALUES ('3'
  5              );

1 row created.

SQL> INSERT INTO test_ord
  2              (col
  3              )
  4       VALUES ('09'
  5              );

1 row created.

SQL> COMMIT ;

Commit complete.

SQL> SELECT   *
  2      FROM test_ord
  3  ORDER BY col;

COL
----------
0111
0123
09
121
3

SQL> SELECT   *
  2      FROM test_ord
  3  ORDER BY TO_NUMBER (col);

COL
----------
3
09
0111
121
0123