hello,

Thanks as usual for your prompt and kind suggestions. i am currently developing a function that is meant to execute dynamically created SQL statements. this is done by concatenating the columns and fetching them via cursors. the problem is that when there is a function with a comma between its arguments, the concat concatenates the contents of the functions inclusive.

Is it possible to skip contents of every bracket found in a string using REGEXP_SUBTR or REGEXP_REPLACE?

Many thanks for the anticipated response.