Beautifier - Column Alias

Niek · Aug 21, 2004

When using quotes for column aliases the Beautifier is not working correctly.

Code:

SELECT last_name  AS "LastName"
       ,first_name AS "FirstName"
FROM   customer

Code:

SELECT last_name  AS lastname
      ,first_name AS "Firstname"
       ,age        AS age
       ,phone      AS "Phone"
FROM   customer

Without the quotes:

Code:

SELECT last_name  AS lastname
      ,first_name AS firstname
FROM   customer

Also when a quote is missing you will get an error. PL/SQL developer is requesting to send the source. Well here it is:

Code:

SELECT last_name  AS LastName"
       ,first_name AS "FirstName"
FROM   customer