How to concatenate large string more than 4000 characters in ORACLE
If there is a need to concatenate string, there are multiple options to concatenate string if length is up to 4000 characters but if the length is more than 4000 characters then it becomes necessary to think about a different approach. In below example, more than 4000 characters string has been concatenated using CLOB…