I would like to be able to format my select statements in Toad so that the equal signs stack up. I was not able to figure out a way to get Toad to format like this.
WRONG
IF p_use_ref_domain_ind = 'Y'
THEN
SELECT rdv.ref_domain_value_desc
INTO v_ref_domain_value_desc
FROM aps.client_preference cp,
aps.property_value pv,
aps.parameter_definition pd,
aps.reference_domain_value rdv
WHERE cp.preference_id = pv.preference_id
AND pv.parameter_definition_id = pd.parameter_definition_id
AND pd.ref_domain_id = rdv.ref_domain_id
AND rdv.ref_domain_value_cd = pv.value_cd
AND pd.label_nm = p_label_nm
AND cp.channel_account_id = p_account_id
AND cp.preference_status_cd = 'S' -- submitted
AND cp.outbound_transmit_tmstp =
(SELECT MAX (outbound_transmit_tmstp)
FROM aps.client_preference cp2
WHERE cp2.outbound_transmit_tmstp <= p_effective_dt
AND cp2.channel_account_id = cp.channel_account_id
AND cp2.preference_status_cd = 'S');
RIGHT
IF p_use_ref_domain_ind = 'Y'
THEN
SELECT rdv.ref_domain_value_desc
INTO v_ref_domain_value_desc
FROM aps.client_preference cp,
aps.property_value pv,
aps.parameter_definition pd,
aps.reference_domain_value rdv
WHERE cp.preference_id = pv.preference_id
