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 personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.