In Toad 10.5.1.3, you cannot manipulate a list for an â€INN†clause in the Formatter Options.
For example,
SELECT last_name, frist_name FROM employees e WHERE e.EMPLOYEE_ID IN ('1', '2', '3', '4', '5', '6','7', '8', '9', '10', '11','12', '13', '14');
If you format this you get the following.
/* Formatted on 6/16/2010 3:40:41 PM (QP5 v5.149.1003.31008) */
SELECT last_name, frist_name
FROM employees e
WHERE e.EMPLOYEE_ID IN
('1',
'2',
'3',
'4',
'5',
'6',
'7',
'8',
'9',
'10',
'11',
'12',
'13',
'14');
If I don't want the 'IN' clause list to line up but rather wrap the list so there is more items per line, there is no way to do that.
WORKAROUND:
None
STATUS:
Enhancement request has been submitted to Development for consideration in a future release of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy