OraFAQ Forum: SQL & PL/SQL » How to concat?

Home » SQL & PL/SQL » SQL & PL/SQL » How to concat?

Tue, 15 October 2002 02:39

Srinivas
Messages: 138
Registered: June 2000

Senior Member

Hi All,
How to concat a long data type value with a varchar2 data type value in my select statement?

Thanks In Advance,
Srinivas.

Tue, 15 October 2002 03:09

siva
Messages: 58
Registered: August 1999

Member

I think 'select field1||field2 from table1'
(field 1 - long datatype column
field 2 - varchar2 column )
should work

Previous Topic:	speed up
Next Topic:	Unix Scripts from PLSQL

Goto Forum:

]

Current Time: Tue May 07 10:11:35 CDT 2024