Hi All,
I have a requirement where i have to fetch mutiple rows of a table and then concatenate the data of a particular field of all the rows and put it into a single variable.
I have no restrictions on the no of rows to be fetched due to which i cannot plan of the size of that single variable.
Can anyone suggest me some data type which can take variable lengths at run time. also the size limit can go beyond 255.
Please help.
Thanks,
Chandna