Error  in  advancedsql
Question

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

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

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.