http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FRegular_Expressions%2FBrackets
Oracle PL/SQL/Regular Expressions/Brackets - История изменений
2026-04-04T08:43:46Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/Regular_Expressions/Brackets&diff=2618&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/Regular_Expressions/Brackets&diff=2619&oldid=prev
Admin: 1 версия
2010-05-26T10:02:07Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==A match for any vowel followed by an "r" or "p"==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> create table TestTable(<br />
2 ID VARCHAR2(4 BYTE) NOT NULL,<br />
3 Description VARCHAR2(40 BYTE)<br />
4 )<br />
5 /<br />
Table created.<br />
SQL><br />
SQL><br />
SQL> insert into TestTable (ID, Description) values("1","1234 5th Street");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("2","1 Culloden Street");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("3","1234 Road");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("4","33 Thrid Road");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("5","One than another");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("6","2003 Movie");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("7","Start With Letters");<br />
1 row created.<br />
SQL><br />
SQL> select * from TestTable;<br />
ID DESCRIPTION<br />
---- ----------------------------------------<br />
1 1234 5th Street<br />
2 1 Culloden Street<br />
3 1234 Road<br />
4 33 Thrid Road<br />
5 One than another<br />
6 2003 Movie<br />
7 Start With Letters<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- A match for any vowel followed by an "r" or "p"<br />
SQL><br />
SQL> SELECT description, REGEXP_INSTR(description,"[aeiou][rp]") where_it_is<br />
2 FROM testTable<br />
3 WHERE REGEXP_INSTR(description,"[aeiou][rp]") > 0;<br />
DESCRIPTION WHERE_IT_IS<br />
---------------------------------------- -----------<br />
One than another 15<br />
Start With Letters 3<br />
SQL><br />
SQL> drop table TestTable;<br />
Table dropped.<br />
SQL><br />
SQL><br />
SQL><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==REGEXP_INSTR(description,"[aeiou][aeiou]"): Look for two consecutive vowels==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> create table TestTable(<br />
2 ID VARCHAR2(4 BYTE) NOT NULL,<br />
3 Description VARCHAR2(30 BYTE)<br />
4 )<br />
5 /<br />
Table created.<br />
SQL><br />
SQL><br />
SQL> insert into TestTable (ID, Description) values("1","1234 5th Street");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("2","1 Culloden Street");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("3","1234 Road");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("4","33 Thrid Road");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("5","One than another");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("6","2003 Movie");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("7","Start With Letters");<br />
1 row created.<br />
SQL><br />
SQL> select * from TestTable;<br />
ID DESCRIPTION<br />
---- ------------------------------<br />
1 1234 5th Street<br />
2 1 Culloden Street<br />
3 1234 Road<br />
4 33 Thrid Road<br />
5 One than another<br />
6 2003 Movie<br />
7 Start With Letters<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- REGEXP_INSTR(description,"[aeiou][aeiou]"): Look for two consecutive vowels:<br />
SQL><br />
SQL> SELECT description,<br />
2 REGEXP_INSTR(description,"[aeiou][aeiou]")<br />
3 where_pattern_starts<br />
4 FROM testTable;<br />
DESCRIPTION WHERE_PATTERN_STARTS<br />
------------------------------ --------------------<br />
1234 5th Street 13<br />
1 Culloden Street 15<br />
1234 Road 7<br />
33 Thrid Road 11<br />
One than another 0<br />
2003 Movie 9<br />
Start With Letters 0<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL> drop table TestTable;<br />
Table dropped.<br />
SQL><br />
SQL><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Select only addresses that contain vowels==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> create table TestTable(<br />
2 ID VARCHAR2(4 BYTE) NOT NULL,<br />
3 Description VARCHAR2(30 BYTE)<br />
4 )<br />
5 /<br />
Table created.<br />
SQL><br />
SQL><br />
SQL> insert into TestTable (ID, Description) values("1","1234 5th Street");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("2","1 Culloden Street");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("3","1234 Road");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("4","33 Thrid Road");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("5","One than another");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("6","2003 Movie");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("7","Start With Letters");<br />
1 row created.<br />
SQL><br />
SQL> select * from TestTable;<br />
ID DESCRIPTION<br />
---- ------------------------------<br />
1 1234 5th Street<br />
2 1 Culloden Street<br />
3 1234 Road<br />
4 33 Thrid Road<br />
5 One than another<br />
6 2003 Movie<br />
7 Start With Letters<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL> --Repetition Operators<br />
SQL><br />
SQL> -- Select only addresses that contain vowels<br />
SQL><br />
SQL> SELECT description, REGEXP_INSTR(description,"[aeiou]") where_pattern_starts<br />
2 FROM testTable<br />
3 WHERE REGEXP_INSTR(description,"[aeiou]") > 0;<br />
DESCRIPTION WHERE_PATTERN_STARTS<br />
------------------------------ --------------------<br />
1234 5th Street 13<br />
1 Culloden Street 4<br />
1234 Road 7<br />
33 Thrid Road 7<br />
One than another 3<br />
2003 Movie 7<br />
Start With Letters 3<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL> drop table TestTable;<br />
Table dropped.<br />
SQL><br />
SQL><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==[whatever]: a match of whatever set of characters is included inside the brackets in any order==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> create table TestTable(<br />
2 ID VARCHAR2(4 BYTE) NOT NULL,<br />
3 Description VARCHAR2(40 BYTE)<br />
4 )<br />
5 /<br />
Table created.<br />
SQL><br />
SQL><br />
SQL> insert into TestTable (ID, Description) values("1","1234 5th Street");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("2","1 Culloden Street");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("3","1234 Road");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("4","33 Thrid Road");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("5","One than another");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("6","2003 Movie");<br />
1 row created.<br />
SQL> insert into TestTable (ID, Description) values("7","Start With Letters");<br />
1 row created.<br />
SQL><br />
SQL> select * from TestTable;<br />
ID DESCRIPTION<br />
---- ----------------------------------------<br />
1 1234 5th Street<br />
2 1 Culloden Street<br />
3 1234 Road<br />
4 33 Thrid Road<br />
5 One than another<br />
6 2003 Movie<br />
7 Start With Letters<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- Brackets<br />
SQL><br />
SQL> -- [whatever]: a match of whatever set of characters is included inside the brackets in any order.<br />
SQL><br />
SQL> SELECT description, REGEXP_INSTR(description, "[ri]") where_it_is<br />
2 FROM testTable;<br />
DESCRIPTION WHERE_IT_IS<br />
---------------------------------------- -----------<br />
1234 5th Street 12<br />
1 Culloden Street 14<br />
1234 Road 0<br />
33 Thrid Road 6<br />
One than another 16<br />
2003 Movie 9<br />
Start With Letters 4<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL><br />
SQL><br />
SQL> drop table TestTable;<br />
Table dropped.<br />
SQL><br />
SQL><br />
<br />
</source></div>
Admin