I have a string like this :
string := ' (sum(x) = 12 and sum(y) = 13 and sum(z) = 14 ) and w = 'p' AND q = 'p' AND l = 'p''
and I need to separate all
sum(...) from the rest of the query:
where_Clause:= w = 'p' AND q = 'p' AND l = 'p' having_Clause := sum(x) = 12 and sum(y) = 13 and sum(z) = 14 and
I'm sure there is a way to do that by
regular_expression but cause I'm very new to oracle pl-sql , I need some help. I was wondering if you could help me with that.