Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can you align on column alias key word AS

Mike KutzJun 6 2018 — edited Jun 7 2018

Is it possible to align your code on the column alias key word "AS" using the SQL*Developer code formatter?

Before:

SELECT

  empno AS employee_id

,ename AS employee_name

,job AS job_text

,mgr AS manager_id

FROM emp;

After

SELECT

  empno AS employee_id

,ename AS employee_name

,job   AS job_text

,mgr   AS manager_id

FROM emp;

Ok, this comes from a StackExchange question:  https://dba.stackexchange.com/questions/208936/vertically-align-sql-tool

MK

This post has been answered by Vadim Tropashko-Oracle on Jun 7 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2018
Added on Jun 6 2018
1 comment
474 views