Jan
30
2009
PL/SQL 11g New Feature ตอนที่3 REGEXP
Written by Administrator   

   REGEXP (Regular Expression Function) เริ่มมีใน Oracle Database 10g  ทำหน้าที่ค้นหารูปแบบตัวอักษรที่อยู่ในข้อมูล  ซึ่งมีด้วยกัน  4 Function 

REGEXP_LIKEREGEXP_INSTR,  REGEXP_SUBSTR, REGEXP_REPLACE

 ขณะที่ Version 11g เพิ่มมาอีก 1 Function  คือ 

 REGEXP_COUNT คือ นับจำนวนครั้งของรูปแบบอักษรที่ค้่นหา  

  คราวนี้  ผม Reveiw เฉพาะ REGEXP_COUNT อย่างเดียวก่อน ไว้ว่างจะร่ายยาวการใช้งานของที่เหลืออีกทีนะครับ  

ตัวอย่าง

  SQL>  SELECT REGEXP_COUNT ('Oracle Database PL/SQL New Feature Cooldb.net Oracle Tutorial in THAI','ora',1,'i')  REG_COUNT  FROM DUAL ;

           REG_COUNT

            2

  อธิบาย  

     ตัวอย่างการหาคำว่า ora  จากประโยค   Oracle Database PL/SQL New Feature Cooldb.net Oracle Tutorial in THAI   เีริ่มหาตั้งแต่ตัวแรก  โดยไม่สนใจ Case Sensitive 

     จะเจอ 2 ครั้ง คือ  Oracle Database PL/SQL New Feature Cooldb.net Oracle Tutorial in THAI 

Parameter  ที่ใช้   Data,Search Pattern,ตำแหน่งเริ่มต้นค้นหา , Match option

Data  = Oracle Database PL/SQL New Feature Cooldb.net Oracle Tutorial in THAI

Search Pattern  =  ora

ตำแหน่งเริ่มต้นค้นหา = 1

Match option  = i  (incase sensitive)

Match  Option อื่นๆ  ได้แ้ก่  c = Case sensitive ,  n = allow period ,  m = allow multiple line ,   x = ignore white space

 

 

 

Comments
Add New Search
Leonida Malakan  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |110.168.232.xxx |2016-07-10 18:36:23
website design bangkok.
Kristal Rolph  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |88.218.65.xxx |2019-11-25 21:59:08
If you don't know how to find the best educational institution in the world
for you, I recommend you to read article that is available by
clicking this url[/url] and also read about possibilities for Boston
university students who are interested in entrepreneurship in this article in order to understand that Boston university is one of the best
educational institutions in the world. Also if you want to be involved in
military exercises you can read about the fact that military-connected
students go to the University of Chicago in this article and you also can go to the University of Chicago. And in the end, if you
want to be connected with the geographical job you have to read about
two researchers from the University of Washington will study the
climate change in the arctic here and order a University of Chicago as one of the best universities that
also has...
Wilmer Keppner  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |212.119.41.xxx |2019-11-28 21:54:01
Hi! If you are going to enter a good educational institution, then I
suggest you to go to the University of Washington because you
can expeditiously prepare and enter this university with one hundred
percent - 100 guarantee. See uw essay prompts in order to learn how to write an essay perfectly, you can also find a
data there where you can buy your ideal study in order to enroll that
university, not even with 100 probability, but with 200
probability. ____________________________________And here are some
more good sources:В  https://lifeisanepisode.com/how-to-find-the-bes... - there is message about the best universities in the world, https://www.internetvibes.net/2019/11/08/opport... - here about one of the best universities - Boston, https://bootcampmilitaryfitnessinstitute.com/20... - and here a little about the University of Chicago, which has a military
board.
Yuri Calmese  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |193.202.14.xxx |2019-11-28 21:54:13
Hi! If you are going to enter a good university, then I advise you to go to
the University of Washington because you can rapidly prepare and
 enroll this university with 100 guarantee. See uw essay prompts in order to learn how to write an essay well, you can also find a
information there where you can buy your ideal thesis in order to enter
that university, not even with 100 probability, but with two hundred
percent probability. ____________________________________And here
are some more helpful sources:В  https://lifeisanepisode.com/how-to-find-the-bes... - there is instruction about the best universities in the world, https://www.internetvibes.net/2019/11/08/opport... - here about one of the best universities - Boston, https://bootcampmilitaryfitnessinstitute.com/20... - and here a little about the University of Chicago, which has a military
board.
Michaela Placek  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |45.145.129.xxx |2019-12-05 23:37:24
Hi! If you are going to enter a good university, then I suggest you to go
to the University of Washington because you can quickly prepare and
 enroll this university with 100 guarantee. See uw essay prompts in order to learn how to write an essay completely, you can also find a
information there where you can buy your ideal study in order
to enroll that educational institution, not even with one hundred
percent probability, but with two hundred percent
probability. ____________________________________And here are some
more suitable sources:В  https://lifeisanepisode.com/how-to-find-the-bes... - there is information about the best universities in the world, https://www.internetvibes.net/2019/11/08/opport... - here about one of the best universities - Boston, https://bootcampmilitaryfitnessinstitute.com/20... - and here a little about the University of Chicago, which has a milita...
Jude Rodda  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |45.145.130.xxx |2019-12-06 21:09:34
If you study at a bad university, then it will be interesting for you to
read the article - Do I Need A university Diploma If I Graduated From
A University That Is Not As Prestigious As New York university ? where
there is information where to buy NYU Supplement Essay . Also, if you are studying at a bad university, then you presumed do not
have access to any programs, so you may be interested to read How Does
Stanford Mobile Help Stanford university Students Achieve Better Academic
Results? This article has information what stanford cisco vpn is. And also, if you still don’t study at a not very good educational
institution , but just choose a university , you should search UChicago Essay Prompts and read an article aboutThe Best Admission Essay Writing Services For
College Or university !
Waldo Betz  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |193.202.87.xxx |2019-12-06 21:19:37
If you study at a bad university, then it will be interesting for you to
read the article - Do I Need A educational institution Diploma If
I Graduated From A University That Is Not As Prestigious As New York
educational institution ? where there is information where to buy NYU Supplement Essay . Also, if you are studying at a not very good educational institution,
then you most likely do not have access to any programs, so you may
be interested to read How Does Stanford Mobile Help Stanford
university Students Achieve Better Academic Results? This article has
information  what stanford cisco vpn is. And also, if you still don’t study at a bad educational institution
, but just choose a  university , you should search UChicago Essay Prompts and read an article aboutThe Best Admission Essay Writing Services For
College Or university !
Ashli Eggins  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |85.208.86.xxx |2019-12-06 21:19:37
If you study at a bad university, then it will be interesting for you to
read the article - Do I Need A university Diploma If I Graduated From
A University That Is Not As Prestigious As New York university ? where
there is information where to buy NYU Supplement Essay . Also, if you are studying at a not very good educational institution,
then you most likely do not have access to any apps, so you may
be interested to study How Does Stanford Mobile Help Stanford
university Students Achieve Better Academic Results? This article has
information  what stanford cisco vpn is. And also, if you still don’t study at a not very good university ,
but just choose a  educational institution , you should search UChicago Essay Prompts and read an article aboutThe Best Admission Essay Writing Services For
College Or educational institution !
Oliver Bilous  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |94.231.216.xxx |2019-12-06 21:23:19
If you study at a bad university, then it will be interesting for you to
read the article - Do I Need A educational institution Diploma If
I Graduated From A University That Is Not As Prestigious As New York
university ? where there is information where to buy NYU Supplement Essay . Also, if you are studying at a bad educational institution, then you
feasible do not have access to any apps, so you may be interested to study
How Does Stanford Mobile Help Stanford university Students Achieve
Better Academic Results? This article has information what stanford cisco vpn is. And also, if you still don’t study at a bad educational institution
, but just choose a  university , you should search UChicago Essay Prompts and read an article aboutThe Best Admission Essay Writing Services For
College Or university !
Yvone Bolig  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |193.202.15.xxx |2019-12-07 01:05:50
If you would like to study at good universities, then you need to know
about their benefits. For example, all top educational institutions
have their own applications. You can read an story about stanford mobile that is called "Technological advantages of studying at top
educational institutions: is Stanford mobile an example of the best app
for Stanford educational institution students?". You also need to
be aware that after you learn about the aids of studying at top
educational institutions and want to enroll in one of them, you need
to write an introductory essay. That is why you can use essayassist to buy Princeton supplement essay or some other introductory essay.
Jude Tanoue  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |193.202.15.xxx |2019-12-07 01:14:47
If you would like to learn at good educational institutions, then you need
to know about their aids. For example, all top
educational institutions have their own applications. You can read an
article about stanford mobile that is called "Technological advantages of studying at top
universities: is Stanford mobile an example of the best app for
Stanford educational institution students?". You also need to be
aware that after you learn about the benefits of learning at top
universities and want to enroll in one of them, you need to write
an introductory essay. That is why you can use essayassist to buy Princeton supplement essay or some other introductory essay.
Roderick Cichosz  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |193.56.64.xxx |2019-12-07 01:14:55
If you would like to study at good universities, then you need to know
about their benefits. For example, all top educational institutions
have their own applications. You can read an composition about stanford mobile that is called "Technological advantages of learning at top
universities: is Stanford mobile an example of the best app for Stanford
university students?". You also need to be aware that after you
learn about the aids of learning at top universities and want to enroll in
one of them, you need to write an introductory essay. That is why you
can use essayassist to buy Princeton supplement essay or some other introductory essay.
Addie Fyke  - PL/SQL 11g New Feature аё•аё­аё™аё—аёµа№€3 REGEXP     |193.202.15.xxx |2019-12-07 01:19:09
If you would like to study at good universities, then you need to know
about their aids. For example, all top universities have their
own applications. You can read an column about stanford mobile that is called "Technological advantages of learning at top
educational institutions: is Stanford mobile an example of the best app
for Stanford educational institution students?". You also need to
be aware that after you learn about the benefits of learning at top
educational institutions and want to enroll in one of them, you need
to write an introductory essay. That is why you can use essayassist to buy Princeton supplement essay or some other introductory essay.
Raymundo Philson  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |103.87.58.xxx |2019-12-15 03:18:06
Extraordinary work right here. We in reality enjoyed what you had to say.
Jackqueline Guzzo  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |104.223.103.xxx |2019-12-21 03:16:06
Old Knight and psychic octopi are real! #TheOA needs your help. #SaveTheOA
Barbar Mayeski  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |198.23.250.xxx |2019-12-28 04:57:10
Alex9, this message is your next piece of info. Please message the agency at
your convenience. No further information until next transmission. This is
broadcast #8867. Do not delete.
Tomika  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |46.29.250.xxx |2020-01-04 16:06:43
Thank you so much! If you want to see me naked click my name!
MargaretMirkovich  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |209.99.172.xxx |2020-01-17 19:13:17
Character problem. empty comment
Clementina  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |165.231.103.xxx |2020-01-23 17:57:53
Thanks for your hard work!
legal prono  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |45.94.232.xxx |2020-01-24 19:05:14
Thanks for writing your blog
michele europe  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |92.82.233.xxx |2020-01-31 03:44:15
i love your website man, keep it up! https://www.youtube.com/watch?v=9Rp4pNZBL9M
BETA Testers Wanted for Ask Sc  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |46.4.230.xxx |2020-01-31 08:08:42
Hi, I am the primary programmer responsible for the Online search engine Scraper
and E-mail Extractor by Creative Bear Tech. I am trying to find potential beta
software testers. If anyone is interested, feel free to let me know. You can DM
me right here or send me a message on https://creativebeartech.com.
CBD Reviewers WANTED - CBD TER  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |95.216.87.xxx |2020-01-31 16:30:13
We are currently trying to find people to review CBD goods from leading CBD
Brands on our blog at cbdlifemag.com. If anybody is interested, please respond
below or DM me and I will get some CBD products, including CBD Pods, CBD
Topicals and CBD CREAMS sent to you for your review.
Yong Vintinner  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |165.231.103.xxx |2020-01-31 19:39:07
Amazing! This has helped me out so much!
Nicola Fiacco  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |45.94.232.xxx |2020-02-01 16:04:53
https://legalporno.home.blog/
Real Estate Video Ads  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |185.153.177.xxx |2020-02-08 11:43:21
Great site, I am sharing this to my social connections.
Ricardo Watahomigie  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |5.181.43.xxx |2020-02-12 20:31:18
Thank you very much for sharing this post. Very much looking forward to hearing
some more in time.
nude video chat  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |185.96.162.xxx |2020-02-25 22:03:51
Great! Thank you so much. Keep up the good work.
blonde milfs  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |185.96.162.xxx |2020-03-01 15:37:02
Thank you for your hard work.
Sofía  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |92.222.77.xxx |2020-03-01 15:42:09
Estar tocado...
Deidra Dute  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |113.169.31.xxx |2020-03-13 22:10:08
Hiện tại, Phạm Thừa Thừa là thí sinh độc nhất dù chưa ra
mắt đã có hợp đồng đại diện thương hiệu cá nhân. Bên công
ty sẽ tương trợ vấn đề sang tên theo đúng luật cho khách dù
bây giờ tách thửa siêu khó”, “cò” L. cam đoan. Nhưng giả dụ
trong giả dụ “lách luật” bằng phương pháp hai bên tậu bán
theo hình thức ủy quyền, thỏa thuận có nhau thì cơ quan quản lý
Nhà nước ko nắm được. Chiếc xe máy chở 3 bạn trẻ cố vượt
1 mẫu xe ô tô đi cùng chiều bất ngờ mất lái rồi tông mạnh
vào lan can bên đường khiến cho một người tử vong, 2 người
nhập viện nguy kịch. Tối 1-2, một số chuyến bay từ Trung Quốc
đưa hành khách Việt Nam về nước đã hạ cánh xuống Cảng Hàng
không quốc tế Vân Đồn, Quảng Ninh. Cục Hàng không Việt...
Jewell Wolfred  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |178.128.85.xxx |2020-03-15 20:00:02
Thanks , I've just been looking for info about this subject for ages and yours
is the greatest I have found out till now. However, what in regards to the
bottom line? Are you sure about the source?|What i don't realize is in fact how
you're now not actually much more smartly-liked than you might be right now. You
are very intelligent.
سکسی فیلم  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |87.236.212.xxx |2020-03-15 23:54:53
Thanks You
Doria Pandola  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |5.253.202.xxx |2020-03-20 01:05:49
help
فیلم س  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |87.236.212.xxx |2020-03-20 03:08:58
Thanks
Alisha  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |92.82.233.xxx |2020-03-21 06:40:10
Gran post allí hombre! Incluí un enlace a él en mi video:
https://youtu.be/2XJILb77exo Espero que no te importe. ¡Gracias!
라이브 바카라  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |23.108.7.xxx |2020-03-22 04:42:32
Brand new boots , every day !
Merlene Houchens  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |112.133.248.xxx |2020-03-22 06:37:14
There is noticeably a bundle to know about this. I assume you made certain nice
points in features also.
Russ Osuna  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |112.133.237.xxx |2020-03-23 15:21:30
Youre so cool! I dont suppose Ive read anything like this before. So nice to
find somebody with some original thoughts on this subject. realy thank you for
starting this up. this website is something that is needed on the web, someone
with a little originality. useful job for bringing something new to the
internet!
Deon Priestly  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |112.133.237.xxx |2020-03-26 16:45:07
This really answered my problem, thank you!
sms dating sites  - PL/SQL 11g New Feature ตอนที่3 REGEXP     |154.45.212.xxx |2020-03-28 11:47:02
Online dating website https://pleasurechase.com - Tags: dating sites,free
dating sites,online dating,dating,dating websites,best dating
sites,freedating,free online dating,online dating sites,best free dating
sites,free online dating sites,best online dating sites,top dating sites,100
free dating sites,free dating websites,dating sites for singles,hookup
sites,women looking for men,internet dating,best dating websites,christian
dating,online dating websites,completely free dating sites,completely free
dating,totally free dating sites,top free dating sites,personally,best free
online dating sites,finding love,dating services,christian dating sites,american
dating sites,local dating sites,popular dating sites,top 10 dating sites,top
free online dating sites,cupid dating site,senior dating,asian dating
sites,christian singles,good dating sites,meet singles for free,new dating
sites,single dating,best dating sites for men,mo...
Write comment
Name:
Email:
 
Website:
Title:
UBBCode:
[b] [i] [u] [url] [quote] [code] [img] 
 
 
:angry::0:confused::cheer:B):evil::silly::dry::lol::kiss::D:pinch:
:(:shock::X:side::):P:unsure::woohoo::huh::whistle:;):s
:!::?::idea::arrow:
 
Please input the anti-spam code that you can read in the image.

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."