i have a following requirement. I am not able to get the desired output. By using Multi namespaces I am able to get for e.g. both Account9999 in a single row in one column.
I need to get "Account" only and need to ignore the "9999" row saw:g
Thanks for any help.
Please don't hijack an old thread to ask your new question. Please start a new thread for your question. Also include your version of Oracle
select * from v$version
In this case, also include the SQL that you have started so we can make corrections to it, or rewrite it, based on what is better.