FROM T_NIS A, T_MEMBERS B WHERE A.F_POSTCODE(+) = REPLACE(B.F_POSCOD, ' ')This REPLACE -- what does it do? Is it similar to NVL?
REPLACE function replaces the occurrence of a sub-string in a string with a specified second sub-string. In the event the second sub-string is not specified, then it removes the occurrence of the first sub-string.
In your example all white spaces will be removed from the valid in B.F_POSCOD column before the equality is ve...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.