Save HTML value to table : VARCHAR2 « SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL Data Types
  3. VARCHAR2
SQL>
SQL>
SQL> create table my_html_docs
  2  ( id number primary key,
  3    html_text varchar2(4000))
  4  /

Table created.

SQL>
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>








10.4.VARCHAR2
10.4.1.Varchar type column
10.4.2.Compare VARCHAR2 type value for equlity
10.4.3.Use Like operator on VARCHAR2 column
10.4.4.Update VARCHAR column
10.4.5.INSTR(first_name,',', 1)
10.4.6.Add an index to a varchar2 type column
10.4.7.varchar2 type column with default value
10.4.8.Not equal operator for varchar
10.4.9.NOT BETWEEN with varchar type
10.4.10.Use IN for varchar type
10.4.11.varchar type not equals or null value
10.4.12.varchar type not equals or not null value
10.4.13.Concatenate strings
10.4.14.Use concatenated string in where clause
10.4.15.Search for String Across Columns
10.4.16.Save HTML value to table
10.4.17.Save xml data to varchar2 type column