Re: HELP : Store Procedure Question ?

From: <andrewfung_at_my-deja.com>
Date: Mon, 21 Jun 1999 09:46:25 GMT
Message-ID: <7kl1lf$66f$1@nnrp1.deja.com>

The following codes may help u :

declare

tmpStr varchar2(50);
begin

SELECT INSTR('Hello Oracle', 'ra', 1, 1) INTO tmpStr
FROM DUAL; -- DUAL is a built-in dummy table

in Oracle end;

In article <376B8664.CC1D6D84_at_sftw.umac.mo>, d951686_at_sftw.umac.mo wrote:
> Hi,
>
> Would you please to teach me howw to use INSTR
and SUBSTR ??
>
> select INSTR(Name, 'O', 1, 1) from data;
>
> the above query can work well in Oracle, right ?
>
> But, how can I use INSTR and SUBSTR not in a
query but in a Store
> Procdure ?
>
> Such as,
>
> declare
> tmpStr varchar2(50);
> begin
>
> tmpStr := INSTR('Hello Oracle', 'ra', 1, 1);
> end;
>
> Is it possible ? Please teach me how to
implement INSTR and SUBSTR ????
>
> Best regards,
> Eric
>
> --
> _

_
> / )

|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \

> / / |

| \ \
> _( /_ | _ Chow Hoi Ka, Eric

_ | _) )_
> (((\ \> |/ )

( \| </ /)))
> (\\\\ \_/ / E-Mail : d951686_at_sftw.umac.mo
\ \_/ ////)
> \ /

\        /


>   \    _/     http://www.sftw.umac.mo/~d951686/


\_     /

> / /

|____________________________________________| \

\
> / /

\ \
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 21 1999 - 04:46:25 CDT