Toad World® Forums

I have a question for formatting SQL queries.


#1

Hello, I have a question for fomatter setting.

I have already set Formatter in the View>Toad Options>Formatter.
But I cannot find how to set ( ) style.

For example… Subqueries in From clause.

SELECT b.company_name, a.host_name, a.perf_item01
FROM (SELECT host_name, perf_item01
FROM perf_cpu_time_info
WHERE reg_date BETWEEN ‘20121101’ AND ‘20121130’
) a,

device_mview b
WHERE a.host_name = b.host_name;

I want to format the query like below.

SELECT b.company_name, a.host_name, a.perf_item01
FROM **(**SELECT host_name, perf_item01
FROM perf_cpu_time_info
WHERE reg_date BETWEEN ‘20121101’ AND ‘20121130’
) a,
device_mview b
WHERE a.host_name = b.host_name;

Please help me. Where can I set this style?