How to Format code so that the Columns in a Select Query are placed one column per line (not wrapped)?
Initially, my query looks likes this after formatting it:
SELECT 'C' AS "fc",
'1' AS "company", b.employee AS "employee", b.pay_code "pay-code", NULL AS "rate",
'20080101' AS "effect-date", '20080101' AS "end-date", NULL AS "currency-code",
b.obj_id AS "obj-id", NULL AS "activity", NULL AS "hours", B.RATE
FROM lawson.standtime b
How do I format my query to look like this:
SELECT 'C' AS "fc",
'1' AS "company",
b.employee AS "employee",
b.pay_code "pay-code",
NULL AS "rate",
'20080101' AS "effect-date",
'20080101' AS "end-date",
NULL AS "currency-code",
b.obj_id AS "obj-id",
NULL AS "activity",
NULL AS "hours",
B.RATE
FROM lawson.standtime b
Go to View | Formatting Options | Statements & Clauses | Other Lists | click on "Reset pane to recommended defaults" Icon. Since you are resetting this section, please remember your original settings before clicking on the said Icon. This will make the columns in a query statement line up one column per line instead of being wrapped.
