|
SQL>
SQL>
SQL> CREATE TABLE lobdemo (
2 key NUMBER,
3 clob_col CLOB,
4 blob_col BLOB);
Table created.
SQL>
SQL>
SQL> column CLOB_Data format a60
SQL> column BLOB_Data format a60
SQL> SELECT key,
2 DBMS_LOB.SUBSTR(clob_col, 50) CLOB_Data,
3 DBMS_LOB.SUBSTR(blob_col, 25) BLOB_Data
4 FROM lobdemo
5 WHERE key IN (0, 100, 101, 102, 103, 1000, 1001, 1002)
6 ORDER BY key;
no rows selected
SQL>
SQL> drop table lobdemo;
Table dropped.
SQL>
|
Tags: and the first 25 bytes of blobcol, Code, dbmslob laquo System Packages laquo Oracle PL SQL, DBMSLOBSUBSTR, dbms_lob, for each row, Oracle PL / SQL, Select the first 50 characters of clobcol, System Packages
Posted in Uncategorized |
This entry was posted
on Thursday, July 2nd, 2009 at 6:29 pm and is filed under Uncategorized.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
