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 to convert a LONG type to Upper Case

246040Apr 3 2002

Hello,
I am presently using Oracle 8.1.6 on NT.

I want to convert data in LONG type column to upper case, and wish to use it in a query. LONG type can typically hold character string information upto max of 2 GB.

UPPER function does not convert a LONG type to upper case.

Can somebody please tell whether there is any way to do it?

I am ready to create a user defined function too.

Regards,
Mukul

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2002

Added on Apr 3 2002

1 comment

553 views