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?