[ OFFSET offset { ROW | ROWS } ]
[ FETCH { FIRST | NEXT } [ { rowcount | percent PERCENT } ]
    { ROW | ROWS } { ONLY | WITH TIES } ]

select  dname,
        (
         select  ename
           from  emp e
           where e.deptno = d.deptno
           order by ename
           fetch first 1 rows only
        ) ename
  from  dept d
/

DNAME          ENAME
-------------- ----------
ACCOUNTING     CLARK
RESEARCH       ADAMS
SALES          ALLEN
OPERATIONS

set long 10000
variable c clob
begin
    dbms_utility.expand_sql_text(Q'[select  dname,
        (
         select  ename
           from  emp e
           where e.deptno = d.deptno
           order by ename
           fetch first 1 rows only
        ) ename
  from  dept d]',:c);
end;
/
 print c

C
--------------------------------------------------------------------------------

SELECT  "A1"."DNAME" "DNAME",
        (
         SELECT  "A2"."ENAME" "ENAME"
           FROM  (
                  SELECT  "A3"."ENAME" "ENAME",
                          "A3"."ENAME" "rowlimit_$_0",
                          ROW_NUMBER() OVER ( ORDER BY "A3"."ENAME") "rowlimit_$$_rownumber"
                    FROM  "SCOTT"."EMP" "A3"
                    WHERE "A3"."DEPTNO"="A1"."DEPTNO"
                 ) "A2"
           WHERE "A2"."rowlimit_$$_rownumber"<=1
        ) "ENAME"
  FROM  "SCOTT"."DEPT" "A1"
/