How to change Formatter settings to wrap values of IN function or put them on one line?
EXAMPLE:
I want the IN values below to be on one line or wrapped.
SELECT 'C' AS "fc", b.employee AS "employee", NULL AS "rate", B.RATE
FROM lawson.standtime b
WHERE b.pay_code = 'ANN' AND TO_CHAR (b.end_date, 'yyyymmdd') = '20081231'
AND b.employee IN
(1684,
5915,
6832,
10802,
11169,
12318,
17034,
29251,
32794,
34323,
35583,
35951,
5911,
4495,
4374);
1. Select View | Formatting Options menu option
2. Select Operators & Punctuations | AND - OR from left side
3. Under Style, check "Wrapped" checkbox
EXAMPLE:
/* Formatted on 8/25/2009 9:55:49 AM (QP5 v5.126.903.23003) */
SELECT 'C' AS "fc", b.employee AS "employee", NULL AS "rate", B.RATE
FROM lawson.standtime b
WHERE b.pay_code = 'ANN' AND TO_CHAR (b.end_date, 'yyyymmdd') =
'20081231' AND b.employee IN (1684, 5915, 6832, 10802, 11169, 12318
, 17034, 29251, 32794, 34323, 35583, 35951, 5911, 4495, 4374);