http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FCharacter_String_Functions%2FCONTAINS
Oracle PL/SQL Tutorial/Character String Functions/CONTAINS - История изменений
2026-04-06T23:33:54Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Character_String_Functions/CONTAINS&diff=4338&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:46Z
<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://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Character_String_Functions/CONTAINS&diff=4339&oldid=prev
Admin: 1 версия
2010-05-26T10:11:32Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== CONTAINS(description, "10g near oracle") > 0==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL> CREATE TABLE book (<br />
2 id NUMBER (10) PRIMARY KEY,<br />
3 isbn VARCHAR2(10),<br />
4 description VARCHAR2(500));<br />
Table created.<br />
SQL><br />
SQL> INSERT INTO book(id,isbn,description)VALUES (1,"3", "The essential PL/SQL.");<br />
1 row created.<br />
SQL> SELECT isbn<br />
2 FROM book<br />
3 WHERE CONTAINS(description, "10g near oracle") > 0;<br />
SELECT isbn<br />
*<br />
ERROR at line 1:<br />
ORA-20000: Oracle Text error:<br />
DRG-10599: column is not indexed<br />
<br />
SQL><br />
SQL><br />
SQL> drop table book;<br />
Table dropped.</source><br />
<br />
<br />
<br />
== CONTAINS(description, "website") > 3==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> CREATE TABLE book (<br />
2 id NUMBER (10) PRIMARY KEY,<br />
3 isbn VARCHAR2(10),<br />
4 description VARCHAR2(500));<br />
Table created.<br />
SQL><br />
SQL> INSERT INTO book(id,isbn,description)VALUES (1,"3", "The essential PL/SQL.");<br />
1 row created.<br />
SQL><br />
SQL> SELECT isbn<br />
2 FROM book<br />
3 WHERE CONTAINS(description, "website") > 3;<br />
SELECT isbn<br />
*<br />
ERROR at line 1:<br />
ORA-20000: Oracle Text error:<br />
DRG-10599: column is not indexed<br />
<br />
SQL><br />
SQL> drop table book;<br />
Table dropped.<br />
SQL></source><br />
<br />
<br />
<br />
== Proximity searches with contains==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> CREATE TABLE book (<br />
2 id NUMBER (10) PRIMARY KEY,<br />
3 isbn VARCHAR2(10),<br />
4 description VARCHAR2(500));<br />
Table created.<br />
SQL><br />
SQL> INSERT INTO book(id,isbn,description)VALUES (1,"3", "The essential PL/SQL.");<br />
1 row created.<br />
SQL><br />
SQL> DECLARE<br />
2 v_isbn book.ISBN%TYPE;<br />
3 v_score NUMBER(10);<br />
4 BEGIN<br />
5<br />
6 SELECT score(1), isbn<br />
7 INTO v_score, v_isbn<br />
8 FROM book<br />
9 WHERE CONTAINS (description, "10g near Oracle", 1) > 0;<br />
10<br />
11 DBMS_OUTPUT.PUT_LINE("Score: "||v_score||" and ISBN: "||v_isbn);<br />
12<br />
13 EXCEPTION<br />
14 WHEN OTHERS<br />
15 THEN<br />
16 DBMS_OUTPUT.PUT_LINE(sqlerrm);<br />
17 END;<br />
18 /<br />
ORA-20000: Oracle Text error:<br />
DRG-10599: column is not indexed<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL> drop table book;<br />
Table dropped.<br />
SQL></source></div>
Admin