Saturday, January 19, 2008

Oracle 10g: Concatenation Operator (||)

Careless mistake that causes severe injury...

MSSQL: +

EXAMPLE:

SELECT * FROM GBL_CIVILANT_MST WHERE ICNO LIKE '%' + SEARCHITEM_ + '%'

ORACLE:

EXAMPLE:

SELECT * FROM GBL_CIVILANT_MST WHERE ICNO LIKE '%' SEARCHITEM_ '%'

No comments: