Hi everyone,
I have the following statement, "VARCHAR2 (a,2,c)", and the outputs I want are "a" , "2" and "c".
There're two problems.
1) How can I ignore the "VARCHAR2 (" and ")" by using the
pattern?
2) Can the extracted "a", "2", "c" in the same group?
I can use subString & split to process it but I'm looking for idea by using pattern to do the same result.
Thanks.