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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center