\n
l_varchar :<\/span>=<\/span> betwnstr(<\/span>'<\/span>hello world<\/span>'<\/span>\n , <\/span>3<\/span>\n , <\/span>5<\/span>\n , <\/span>true<\/span>);\n\nl_varchar :<\/span>=<\/span> betwnstr(<\/span>'<\/span>hello world<\/span>'<\/span>\n , <\/span>3<\/span>\n , <\/span>5<\/span>);\n\nl_varchar :<\/span>=<\/span> betwnstr( string_in <\/span>=><\/span> <\/span>'<\/span>hello world<\/span>'<\/span>\n , start_in <\/span>=><\/span> <\/span>3<\/span>\n , end_in <\/span>=><\/span> <\/span>5<\/span>\n , inclusive_in <\/span>=><\/span> <\/span>true<\/span>);\n\nl_varchar :<\/span>=<\/span> betwnstr( string_in <\/span>=><\/span> <\/span>'<\/span>hello world<\/span>'<\/span>\n , start_in <\/span>=><\/span> <\/span>3<\/span>\n , end_in <\/span>=><\/span> <\/span>5<\/span>);<\/span><\/div><\/pre>\n<\/div>\n<\/p>\n
Which one of these calls is better? Oracle doesn’t mind. To the PL\/SQL engine they are all valid and all correct. I don’t even think there is a performance issue with either one of them.<\/p>\n
<\/p>\n
What are my thoughts on this issue:
– Calling programs with parameters by name is better because you can skip the defaulted parameters which are in between other (non defaulted) parameters.
– Calling programs with parameters by name is better because it’s more self documenting, you describe what variable goes into what parameter.
– If you rearrange the parameters, for whatever reason, your programs calling this one will still be working.<\/p>\n
Calling programs with parameters by position is better because… well, not many pros I can think of for this approach. It’s mostly ‘old’ code I come across that calls programs with parameters by position. I always have to check the called program to see what the parameters mean.<\/p>\n
Which one (in your opinion) is better.<\/p>\n","protected":false},"excerpt":{"rendered":"
In Oracle PL\/SQL you have the possibility to call another program with parameters either by position or by name. Both have their pros and cons I think. Consider the betwnstr function (posted last time) and these calls (all have the same result): l_varchar := betwnstr(‘hello world’ , 3 , 5 , true); l_varchar := betwnstr(‘hello […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,5],"tags":[],"class_list":["post-158","post","type-post","status-publish","format-standard","hentry","category-oracle","category-plsql"],"_links":{"self":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/posts\/158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=158"}],"version-history":[{"count":0,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/posts\/158\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}