Oracle Regular Expression | Tamil Tutorial | iCoding

[@mohan1958]

Nice work, Thanks. It is not easy to teach regular expressions but you made it! My videos are also on you tube..

[@harishselvam1383]

Your videos helpful to us 🎊🎉thank you 🥳

[@SelvaKumar-hg3ho]

Great exploration pls upload more topic

[@velumani1695]

super bro... nd inum more then videos ah podunga....

[@dhineshkumarg2899]

My text is having alphabets nukbers , space and .,/-. HOW can i use regexp to select only the text having alphabets numbers and .-/

[@VIJAYKUMAR.S-qf4bp]

Hi bro
Special characters matum filter panna comments solunga...

[@samwesley7236]

explained greatly...

[@forthepeople7887]

Great explanation. 👏🏻👏🏻👏🏻

[@manoharanmalathi3041]

Hi...
I have interview questions like
'Apple' word - substring function use pannama each character to act like each column plz help to this and
Thank you 😊

[@iCodingTamil]

Select replace(lpad ('apple',level),lpad('apple',level-1),'') from dual connect by level

[@pankajkharade6936]

Select Substr( 'Apple',Level,1) Output From DUAL
Connect By Level

[@pradeepmca]

@@iCodingTamil This is a gr8 alternate solution. You could have included explanation for replace with 2 parameters in video dedicated for oracle functions. Nevertheless i referred Oracle documentation to understand what if we don't give 3rd replace parameter, it just omitts and takes the 2nd search string and removes the search string from 1st parameter.

[@rameshbabu3837]

Plsql video podunga bro

[@justjeeva1462]

Vera11 bro

[@shylajasaravanabava8225]

Hi sir, i need one query to display the name of all contacts having 5th digit of their phone number as '5' using REGEXP_SUBSTR

[@mathankumar2228]

Podu sema..

[@yasararafath6389]

Thala Idhu SQL thane?

[@iCodingTamil]

Ama bro

[@pradeepmca]

This is a great session on regex.
select emailaddress from user_ where REGEXP_LIKE (emailaddress, '^[a-z]+', 'i')
The above query is returning [e-mail] & [e-mail]. How to restrict [e-mail],as it is containing number 4?