sql - Regular expression Oracle -

i learning use regular expressions , i'm using them limit results of search query using regexp_like in oracle 11. placing example of data available, have following:

plan navegación 200 mb plan navegación 1 gb plan navegación 1 gb plan de navegacion 3g plan de navegacion 4g plan de navegacion 3g empresarial plan de navegacion 4g empresarial plan de servicios 3g plan de servicios 4g plan navegación datos 

i want result limited following (only 3g, 4g):

plan de navegacion 3g plan de navegacion 4g plan de navegacion 3g empresarial plan de navegacion 4g empresarial 

i using following search pattern did not filtered results:

• upper(plan_gsm),'(navega){1}|(3g|4g|5g)'
• upper(plan_gsm),'((navega)+)(3g|4g)+'

i have done several tests , not find solution. give me hints?

you use like, below:

select * mytable plan_gsm 'plan de navegacion _g%'; 

or use regexp_like, below:

select * mytable regexp_like(plan_gsm, '^plan de navegacion (3|4|5)g(*)'); 

sql fiddle demo

reference:

oracle/plsql: regexp_like condition on tech on net