Oracle大數據類型的操作之一CLOB作者: CCBZZP ;大家在應用ORACLE的時候, 可能經常會用到對大數據類型的操作, 在這里我簡單的總結一下, 希望對大家能有所幫助! 也歡迎大家一起來探討, 以便共同進步, 共同發(fā)展! 本文對ORACLE的高手來說是不用看的.1. 如何創(chuàng)建帶有CLOB類型字段的表? CREATE TABLE TEST2 (AAA CLOB);2. 如何對帶有CLOB類型字段的表增加記錄? INSERT INTO TEST2 VALUES('CCBZZPCCBZZP');3. 如何SELECT帶有CLOB類型字段的表? SELECT * FROM TEST2; SELECT * FROM TEST2 WHERE DBMS_LOB.INSTR(TEST2.AAA,'B',1,1)>0;4. 如何對帶有CLOB類型字段的表更換表空間? ALTER TABLE; TEST2 MOVE TABLESPACE USERS;5. 如何EXP帶有CLOB類型字段的表? EXP USER/PASSWord FILE=A.DMP; TABLES=(TEST2);6. 如何IMP帶有CLOB類型字段的表? IMP USER/PASSWORD FILE=A.DMP FULL=Y;7. 從哪個版本開始支持CLOB,BLOB等大字段? 8.0以上測試環(huán)境為ORACLE92SQL*Plus: Release 9.2.0.1.0 - ProdUCtion on 星期四 9月 4 12:02:00 2003Copyright (c) 1982, 2002, Oracle Corporation.; All rights reserved.連線到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - ProductionSQL> DROP TABLE TEST2;DROP TABLE TEST2 *ERROR 在行 1:ORA-00942: 表格或視觀表不存在SQL>CREATE TABLE TEST2 (AAA CLOB);已建立表格.SQL> INSERT INTO TEST2 VALUES('CCBZZPCCBZZP');已建立 1 個資料列.SQL> SELECT * FROM TEST2;AAA--------------------------------------------------------------------------------CCBZZPCCBZZPSQL> SELECT * FROM TEST2 WHERE DBMS_LOB.INSTR(TEST2.AAA,'B',1,1)>0;AAA--------------------------------------------------------------------------------CCBZZPCCBZZPSQL> ALTER TABLE; TEST2 MOVE TABLESPACE USERS;已更改表格.SQL> d:> exp test/test file=a.dmp tables=(test2)......Export done in ZHT16BIG5 character set and ZHT16BIG5 NCHAR character set About to export specified tables via Conventional Path .... . exporting table; TEST2; 0 rows exportedExport terminated successfully without warnings.SQL> drop table test2;已刪除表格.d:> imp test/test file=a.dmp tables=(test2);...... import done in ZHT16BIG5 character set and ZHT16BIG5 NCHAR character set. importing TEST's objects into TEST. . importing table;;;;;'TEST2'; 0 rows importedImport terminated successfully without warnings. 待續(xù)...