Split string in PLSQL -
following should homecoming y
casisa#y invopt#lumreg#lumsum#2000#regsum#8000 lumsum#2000#regsum#8000 i.e hash separates code , value , separates code, value pairs (earlier semicolon used separate code, value pairs)
following should homecoming n (as these wrong input string formats)
casisa# invopt#lumreg#lumsum lumsum#2000#regsum#8000#
case when regexp_like(your_string||'#', '^(\w+#\w+#)+$') 'y' else 'n' end
sql fiddle
plsql
No comments:
Post a Comment