Mega Code Archive
Save HTML value to table
<![CDATA[
SQL>
SQL> create table my_html_docs
2 ( id number primary key,
3 html_text varchar2(4000))
4 /
Table created.
SQL>
SQL> insert into my_html_docs( id, html_text )
2 values( 1,
3 '<html>
4 <title>Oracle</title>
5 <body>This</body>
6 </html>' )
7 /
1 row created.
SQL>
SQL> select id from my_html_docs where contains( html_text, 'Oracle' ) > 0
2 /
select id from my_html_docs where contains( html_text, 'Oracle' ) > 0
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed
SQL>
SQL> drop table my_html_docs;
Table dropped.
SQL>
]]>