CLOB COLUMN을 조회하는 방법
--------------------------
1. CLOB Table 생성.
SQL> create table clob1 (clobcol clob);
Table created.
2. 문자열 데이터 입력.
SQL> insert into clob1 values
('Oracle9i provides everything you need to deploy fast,
scalable internet applications to run your business.');
1 row created.
SQL> insert into clob1 values
('Two products, Oracle9i Application Server and Oracle9i Database,
deliver the industry highest performance, reliability and security.');
1 row created.
3. CLOB COLUMN을 조회.
SQL> select * from clob1
where clobcol like '%Oracle9i Application Server%';
2 where clobcol like '%Oracle9i Application Server%'
*
ERROR at line 2:
ORA-00932: inconsistent datatypes
SQL> set long 10000
SQL> select * from clob1
where dbms_lob.instr(clobcol, 'Oracle9i Application Server')>0;
CLOBCOL
--------------------------------------------------------------------------------
Two products, Oracle9i Application Server and Oracle9i Database,
deliver the industry highest performance, reliability and security.
아울러 jsp 에서 clob insert,select 를 할수 있는 소스를 EtcTip에 올려져 있습니다. 참고 바랍니다.
|