Hi,
I'm trying to generate a SQL query output with open and close bracket need to provide this output for a req.
Now I'm using the following query to achieve this.
select '[' from dual
union all
select account_numbr from table
union all
select ']' from dual
out put:
[1,2,34,56]
Do you have any function to achieve this to get the out put with open and close brackets?
I appreciate your inputs on this.
Thanks,
Kumar