Want an 'e' followed by any number of other characters and then another 'e' : Meta characters « Regular Expressions Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Regular Expressions Functions
3. Meta characters

SQL>
SQL> -- create demo table
SQL> create table myTable(
  2    id           NUMBER(2),
  3    value        VARCHAR(50)
  4  );

Table created.

SQL>
SQL> insert into myTable(id, value)values(1,'1234 4th St. Vancouver');

1 row created.

SQL> insert into myTable(id, value)values(2,'4 Maple Ct. New York');

1 row created.

SQL> insert into myTable(id, value)values(3,'4321 Green Blvd. London');

1 row created.

SQL> insert into myTable(id, value)values(4,'33 Third St. Toronto');

1 row created.

SQL> insert into myTable(id, value)values(5,'One First Drive. Queen');

1 row created.

SQL> insert into myTable(id, value)values(6,'1664 1/2 Springhill Ave');

1 row created.

SQL> insert into myTable(id, value)values(7,'665 Fall Ave. Linken');

1 row created.

SQL>
SQL> select * from mytable;

        ID VALUE
---------- --------------------------------------------------
         1 1234 4th St. Vancouver
         2 4 Maple Ct. New York
         3 4321 Green Blvd. London
         4 33 Third St. Toronto
         5 One First Drive. Queen
         6 1664 1/2 Springhill Ave
         7 665 Fall Ave. Linken

7 rows selected.

SQL>
SQL>
SQL> SELECT value,
  2      REGEXP_SUBSTR(value,'e.+e'),
  3      REGEXP_INSTR(value, 'e.+e') "@"
  4  FROM myTable;

VALUE        REGEXP_SUBSTR(VALUE,'E.+E')      @
1234 4th St. Vancouver       0         4 
Maple Ct. New York                               
e Ct. Ne       7
4321 Green Blvd. London       0
33 Third St. Toronto       0
One First Drive. Queen                             
e First Drive. Quee       3
1664 1/2 Springhill Ave       0
665 Fall Ave. Linken                               e. Linke
      12

7 rows selected.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL>
SQL>