create table test_multi (
col1 varchar2(20),col2 number(11));

insert into test_multi values ('GARY',10);
insert into test_multi values ('FRED',20);
insert into test_multi values ('NED',30);
insert into test_multi values ('JOHNNIE',40);
insert into test_multi values ('JILL',500);

select * from test_multi
where regexp_like(COL1,'^(JI|G)');

COL1                             COL2
-------------------- ----------------
GARY                               10
JILL                              500

select * from test_multi
where regexp_like(COL1,'(ED)$');

COL1                             COL2
-------------------- ----------------
FRED                               20
NED                                30

SCOTT@orcl> select * from test_multi
  2  /

COL1                       COL2
-------------------- ----------
GARY                         10
FRED                         20
NED                          30
JOHNNIE                      40
JILL                        500

5 rows selected.

SCOTT@orcl> select * from test_metadata
  2  /

REG_EXP_COND
------------------------------
^(JI|G)
(ED)$

2 rows selected.

SCOTT@orcl> select t2.reg_exp_cond, t1.col1, t1.col2
  2  from   test_multi t1, test_metadata t2
  3  where  regexp_like (t1.col1, t2.reg_exp_cond)
  4  order  by t2.reg_exp_cond
  5  /

REG_EXP_COND                   COL1                       COL2
------------------------------ -------------------- ----------
(ED)$                          FRED                         20
(ED)$                          NED                          30
^(JI|G)                        GARY                         10
^(JI|G)                        JILL                        500

4 rows selected.