Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help: PL/SQL problem

Help: PL/SQL problem

From: <u132781982_at_spawnkill.ip-mobilphone.net>
Date: Sun, 18 Mar 2001 23:42:33 GMT
Message-ID: <l.984958957.1646118164@ip-20-138-46.dc-g.navipath.net>

Hi, folks,

I write a PL/SQL as follows,

create or replace procedure p as

	cursor c_p is select agm 
        from raw_nolinks; 
	i number;
 	fwd_what varchar2(10);
 begin 
	for v_p in c_p loop 
   	for i in 1..15 loop 
        If substr(v_p.agm,i,1) = 'T' 
        then /* 
	(1)do somthing like: fwd_what :='fwd_what'||i;

question is how to do the (1)do somthing like:
       fwd_what :='fwd_'||i

in PL/SQL?

Thank you very much for your help.  

-- 
Sent by dbadba62  from hotmail  within field  com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Sun Mar 18 2001 - 17:42:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US