SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How we will Conctenate long column with char column?

Sid_ Z.May 8 2018 — edited May 9 2018

Hi All,

Version - Oracle 11gR2

I have one requirement where I need to concatenate a long datatype column with char/varchar column.

While doing this I am getting an error of "Inconsistence datatypes ora-932".

Can we have other way around for this?

e.g

Select 'Some text '|| text

from user_views;

As all we know the TEXT column in USER_VIEWS is of LONG datatype.

Regards,

Sid

This post has been answered by odie_63 on May 9 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2018

Added on May 8 2018

11 comments

1,029 views