--
-- Build_regexp_like
--
-- Includes the regexp_substr construct
--
set echo off
set sqlprompt ""
set trims on
set pagesize 0
set feedback off
set linesize 132
set verify off
--undefine table
--
--
--prompt These variables required:
--prompt >   String (attribute or string literal)
--prompt >   Pattern
--prompt >   Data source (table or dual)
--prompt
accept string prompt 'String (double quotes for a literal)       :'
accept patter prompt 'The Pattern       :'
accept from   prompt 'Tname or Dual:'
--
select ' ' from dual;
--
spool a.sql
select
'select &string string,regexp_substr('||'&string'||','''||'&patter'||''') result '||chr(10)||
'from &from where regexp_like('||'&string'||','''||'&patter'||''');'
from dual;
spool off
--
select ' ' from dual;
--
set sqlprompt "SQL>"
set trims on
set pagesize 999
set feedback on
set verify on
@a
set echo on