Toad World® Forums

Beta Released (12.11.0.39)

Beta Notes:

Formatter Layout

Aligning right hand side of relational expression to left hand side, for better readability.
Both LHS and RHS are considered to be at a same level, not subordinate, so indenting the RHS it not desired.
Examples:

IF INSTR (p_version,
‘.’) >
0
THEN

IF isnull(
b.id),
1000,
b.id) =
c.id
THEN

Formatter Layout

Aliases in select lists now wrapped onto on a new line when right alignment for all is not possible.
This should improve readability by avoiding scattering aliases between left to right.
Examples (before -> after):

SELECT /*+ ALL_ROWS */
so_custid,
ship_zip,
SUM (DECODE (bought_flag, ‘Y’, DECODE (status, 40, 0, 1), 0))
bought,
SUM (DECODE (bought_flag, ‘Y’, 1, 0))
bought_count,
SUM (
DECODE (bought_flag,
‘Y’, DECODE (lost_flag, ‘Y’, DECODE (GREATEST (bought_ts, lost_ts), bought_ts, 1, 0), 0),
0))
stolen_count
FROM md_order_lines

Formatter Layout

Named parameters: On overflow the right side of the arrow is wrapped onto a new line.
Examples:

BEGIN
IF LOWER (p_debug) = ‘debug’
THEN
utl_krg.msg_log.log_debug_msg (
p_caller => g_my_schema || ‘.’ || g_my_package || ‘.’ || l_my_routine,
p_msg_id => g_my_msg_prefix || ‘9110D’,
p_message => 'build_customer_msg returned ’ || COALESCE (l_errmsg2, ‘<*Null>’));
END IF;
END;

BEGIN
IF LOWER (p_debug) = ‘debug’
THEN
utl_krg.msg_log.log_debug_msg (
p_caller =>
g_my_schema || ‘.’ || g_my_package || ‘.’ || l_my_routine,
p_msg_id =>
g_my_msg_prefix || ‘9110D’,
p_message =>
'build_customer_msg returned ’ || COALESCE (l_errmsg2, ‘<*Null>’));
END IF;
END;

BEGIN
IF LOWER (p_debug) = ‘debug’
THEN
utl_krg.msg_log.log_debug_msg (
p_caller =>
g_my_schema
|| ‘.’
|| g_my_package
|| ‘.’
|| l_my_routine,
p_msg_id =>
g_my_msg_prefix
|| ‘9110D’,
p_message =>
'build_customer_msg returned ’
|| COALESCE (
l_errmsg2,
‘<*Null>’));
END IF;
END;

User Settings

The default location for your user files has changed once more as part of the re-branding process, and should now be located back under “%AppData%/Quest Software”. As a result, you may need to recopy your user settings if they don’t automatically come over.