18.1 – New Formatting Option, Right-Align Query Keywords

Due to popular demand, we’ve added this new preference to the formatter. With it turned on:

Some folks hate this, like Connor.

On

SELECT B.DEPARTMENT_NAME,
       A.FIRST_NAME,
       A.LAST_NAME,
       A.SALARY
  FROM DEPARTMENTS B,
       EMPLOYEES A
 WHERE A.EMPLOYEE_ID = B.MANAGER_ID
   AND B.DEPARTMENT_ID (+) = A.DEPARTMENT_ID
 ORDER BY SALARY DESC,
          LAST_NAME ASC;

Off

SELECT B.DEPARTMENT_NAME,
       A.FIRST_NAME,
       A.LAST_NAME,
       A.SALARY
FROM DEPARTMENTS B,
     EMPLOYEES A
WHERE A.EMPLOYEE_ID = B.MANAGER_ID
      AND B.DEPARTMENT_ID (+) = A.DEPARTMENT_ID
ORDER BY SALARY DESC,
         LAST_NAME ASC;

As always, send us your feedback! Example code always helps us make improvements.

关注dbDao.com的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569