Thanks Gopa, it worked.
On Tue, Jan 4, 2011 at 12:29 AM, Gopakumar Pandarikkal <
pandarik...@gmail.com> 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" <gd0...@gmail.com> 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 Oracle-PLSQL@googlegroups.com
> To unsubscribe from this group, send email to
> oracle-plsql-unsubscr...@googlegroups.com
> 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 Oracle-PLSQL@googlegroups.com
> To unsubscribe from this group, send email to
> oracle-plsql-unsubscr...@googlegroups.com
> 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 Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
