Oracle 12c Installed ... New "fetch" Feature in Oracle 12c

Oracle released its latest version of its database last week .
Installed it this week and started playing with that.

DBCA
====

While creating database via dbca , it has two buttons "Alert Log" and "Activity Log" . By clicking on "Alert Log" , a Java popup window displays the contents of the (legacy ) alert log.

SQL Feature
===========

Started with the "tiny" new feature in SQL . I believe , it will be useful in pagination queries.


SQL> select empno , ename , hiredate from emp order by hiredate;

     EMPNO ENAME      HIREDATE
---------- ---------- ---------
      7369 SMITH      17-DEC-80
      7499 ALLEN      20-FEB-81
      7521 WARD       22-FEB-81
      7566 JONES      02-APR-81
      7698 BLAKE      01-MAY-81
      7782 CLARK      09-JUN-81
      7844 TURNER     08-SEP-81
      7654 MARTIN     28-SEP-81
      7839 KING       17-NOV-81
      7900 JAMES      03-DEC-81
      7902 FORD       03-DEC-81
      7934 MILLER     23-JAN-82
      7788 SCOTT      19-APR-87
      7876 ADAMS      23-MAY-87

14 rows selected.


SQL> select empno , ename , hiredate from emp order by hiredate  fetch first 50 percent rows only;

     EMPNO ENAME      HIREDATE
---------- ---------- ---------
      7369 SMITH      17-DEC-80
      7499 ALLEN      20-FEB-81
      7521 WARD       22-FEB-81
      7566 JONES      02-APR-81
      7698 BLAKE      01-MAY-81
      7782 CLARK      09-JUN-81
      7844 TURNER     08-SEP-81

7 rows selected.

As it can be seen from the example , I can display only the part of the resultset based on %.

Will continue to explore and post my findings as I come across.

Comments Welcome.