Regular Expression in Oracle
Oracle 10 g introduced regular expressions. Regular expressions are the special type of notation which is used to search/match/replace strings. Regular expressions are also called as posix notations.
In oracle regular expressions work with CHAR, VARCHAR, VARCHAR2, CLOB datatype but regular expressions doesn't work with LONG datatype. Regular expression having so many meta characters through these meta characters we can search or match or replace strings. Meta characters are the special characters having special meaning.
Oracle having following predefined regular expression functions:
1) Regexp_like()
2) Regexp_instr()
3) Regexp_substr()
4) Regexp_replace()
5) Regexp_count()
Please do check our daily posts, videos for beneficial informations, in case of any additional queries please do contact us, we are happy to assist you.
Please Do SUBSCRIBE our Youtube Channel and Support us :-
https://www.youtube.com/a4uofficial
https://www.youtube.com/a4uofficial
If any difficulties regarding our posts, videos or other problem you can direct contact us:- allforyoucreators@gmail.com
If you found this post was helpful then please don't forget to SUBSCRIBE our channel.
Subscribe us for more such posts, videos and updates.. It's Free!!
Subscribe here : https://www.youtube.com/a4uofficial
For Businesses Inquiries :- allforyoucreators@gmail.com
_____________________________________________________________________________
Join Us on Social Media -
Like our Facebook Page :- https://www.facebook.com/a4u0fficial/
Follow me on Instagram :- https://www.instagram.com/allforyouofficial.01/
Twitter :- https://twitter.com/a4uofficial
Website :- https://allforyouofficial.com/
PLEASE SUBSCRIBE US FOR MORE POSTS, VIDEOS AND STAY TUNED..
CREATIVE, INFORMATIVE & BENEFICIAL CONTENTS TO BE FOUND ON OUR CHANNEL!!
BECAUSE WE KEEP UPLOADING VIDEOS ON YOUTUBE FOR YOU..
ALL WE NEED IS YOUR SUPPORT ❤
=▶ Thanks for your Love and Support ◀=
Copyright ©All For You Official
0 Comments