Hi all. I like Toad formatter, but I want to change the way it formats parentheses and semi-colon with SQL Statements. Here is a sample to explain what it current does (after I have fiddled with formatter settings) and what I would like to get (for which I cannot find any settings to affect the change).
Notice please two things: (1) the open/close parens are aligned, 2) the semi-colon that ends the sql is also aligned with the original DML statment on its own line.
How do I get Toad formatter to do this? The first formatting is highly annoying to look at as it makes it very difficult to know where pieces of the statement start and stop.
PROCEDURE add_tab_privs(grantee_p VARCHAR2)
IS
BEGIN
SELECT CAST(MULTISET(SELECT *
FROM (SELECT * FROM TABLE(CAST(o_kev_privilege_set_v.tab_priv AS c_kev_tab_priv))
UNION
SELECT DISTINCT grantee, owner, table_name
, privilege
FROM dba_tab_privs
WHERE grantee = grantee_p
ORDER BY 1, 2, 3
, 4)) AS c_kev_tab_priv)
INTO o_kev_privilege_set_v.tab_priv
FROM DUAL;
END;
PROCEDURE add_tab_privs(grantee_p VARCHAR2)
IS
BEGIN
SELECT CAST(
MULTISET(
SELECT *
FROM (
SELECT *
FROM TABLE(
CAST(
o_kev_privilege_set_v.tab_priv AS
c_kev_tab_priv
)
)
UNION
SELECT DISTINCT grantee, owner, table_name
, privilege
FROM dba_tab_privs
WHERE grantee = grantee_p
ORDER BY 1, 2, 3
, 4
)
) AS c_kev_tab_priv
)
INTO o_kev_privilege_set_v.tab_priv
FROM DUAL
;
END;
Kevin.