|
SQL>
SQL>
SQL> set echo on
SQL>
SQL>
SQL> create table t ( str varchar2(10), lob clob );
Table created.
SQL>
SQL> insert into t values ( 'hello', 'hello' );
1 row created.
SQL>
SQL> select substr( str, 3, 2 ), dbms_lob.substr( lob, 3, 2) lob
2 from t
3 /
SU
--
LOB
--------------------------------------------------------------------------------
ll
ell
SQL>
SQL> drop table t;
Table dropped.
|