Thanks Gopa, it worked. On Tue, Jan 4, 2011 at 12:29 AM, Gopakumar Pandarikkal < [email protected]> wrote:
> Convert variable into a string and concatenate it with the expression of > the regular expression. > > regards > Gopa > > On Jan 4, 2011 11:06 AM, "gayathri Dev" <[email protected]> wrote: > > Hi All, > > I have a question on Regular Expression. > > When I am using below statement in PL/SQL block, I am not able to use > variable *chr_cnt* > > col_str := regexp_substr(tmp_str1, '[[:alpha:]]{1,*chr_cnt*}'); > > Instead > > col_str := regexp_substr(tmp_str1, '[[:alpha:]]{1,2}'); > works. > > > How can I use a variables in the regexp_substr? > > Thanks, > G > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
