Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP- Code for SQL Single Row Character Function?
I'm trying to write a function long2ch() to convert
table's LONG column to varchar2 so that I could run
select * from tab where long2ch(long_col) like '%MY String%'.
-- I want to make long2ch() similar to upper(), trim()...
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<td6dnS1tV7o1_MncRVn-vQ_at_comcast.com>...
> "Mario King" <hliji_at_yahoo.com> wrote in message
> news:a3f90977.0409240944.5a131be_at_posting.google.com...
> | Hi,
> |
> | Does anyone know the PL/SQL code behind SQL Single Row Character Function,
> | for example, UPPER()?
>
> um, why?
>
> the upper() function and other standard functions are likely written in C,
> certainly not PL/SQL -- they've existed in Oracle long before PL/SQL existed
>
> what are you trying to learn or accomplish?
>
> ++ mcs
Received on Thu Sep 30 2004 - 10:27:51 CDT