Hello,
I like to return the string between two commas. But looks like my syntax is wrong. Can someone please help?
Eg. return hello from the string ('test, hello, done')
My Below sql is not giving the correct result.
select 'test, hello, done', substr('test, hello, done', instr( substr('test, hello, done', 1, length('test, hello, done') ), ',', 1), instr( substr('test, hello, done', 1, length('test, hello, done') ), ',', -2)) from dual
, hello, don
string should be: hello