Hi,
I tried below query to concate two attributes in a table but it is showing syntax error. So, some one can help me in this
select r_object_id, concat(user_name,user_address) as res from dm_user
Regards,
Mars
There's no concat function in DQL.
What are you trying to achieve here?
If this is for a data dictionary list, ie something long term, you can create a view in the database, and then query on the view. In other words, put all your massaging and manipulations at the database level where you have a richer set of SQL commands available to you. –Kyle Pettit, WAVE TSG.
Try this: select r_object_id, user_name+user_address as res from dm_user
-karthik
It seems to work with SQL Server DB but not with Oracle for example.
In my mind, the '+' operator is validated by the syntax checking but it is passed "as it is" to the correspondent SQL query, that's all
