Getting the below error mentioned in the snap. let me know any changes to be made on the query
Hi Aswin,
the problem is with the STUFF function. It doesn't exist in Oracle.
You can find replacer for that function in this topic:
https://community.oracle.com/tech/developers/discussion/3955149/equivalents-to-sql-servers-stuff-function
Regards
Hello @Aswin Parthiban,
A cursory look of the SQL does not reveal any missing right paranthesis, but I was wondering if the root cause lies in how you are using {Report_DB}.[Id] since it is not supported by a JOIN condition anywhere.
Regards,
AJ