Last August 2003 someone asked a question about using string concatenation in a select statement. Effectively, was there an equivalent HQL statement to the SQL statement



One of the developer team said that it was in the queue. Has there been any update? If so, could someone provide an example? It would be especially helpful to see a HQL version and a Criteria version.

The book mentions how to use string concatenation in where clauses (section 7.2.6) but not in selects. FWIW, I'm using:

Hibernate version: version 2.1.6, 9.8.2004

Name and version of the database you are using: Oracle 8i

Thanks,
Alex

Is there a concat function in oracle? If yes, you can do something like "select concat(a.name, a.firstname) from Person a"

I'm guessing your response means that string concat select hasn't made it in the codebase, yet. :) I'll go down the oracle function path, then. Thanks!

Alex