Oracle大數(shù)據(jù)類(lèi)型的操作之一CLOB作者: CCBZZP ;大家在應(yīng)用ORACLE的時(shí)候, 可能經(jīng)常會(huì)用到對(duì)大數(shù)據(jù)類(lèi)型的操作, 在這里我簡(jiǎn)單的總結(jié)一下, 希望對(duì)大家能有所幫助! 也歡迎大家一起來(lái)探討, 以便共同進(jìn)步, 共同發(fā)展! 本文對(duì)ORACLE的高手來(lái)說(shuō)是不用看的.1. 如何創(chuàng)建帶有CLOB類(lèi)型字段的表? CREATE TABLE TEST2 (AAA CLOB);2. 如何對(duì)帶有CLOB類(lèi)型字段的表增加記錄? INSERT INTO TEST2 VALUES('CCBZZPCCBZZP');3. 如何SELECT帶有CLOB類(lèi)型字段的表? SELECT * FROM TEST2; SELECT * FROM TEST2 WHERE DBMS_LOB.INSTR(TEST2.AAA,'B',1,1)>0;4. 如何對(duì)帶有CLOB類(lèi)型字段的表更換表空間? ALTER TABLE; TEST2 MOVE TABLESPACE USERS;5. 如何EXP帶有CLOB類(lèi)型字段的表? EXP USER/PASSWord FILE=A.DMP; TABLES=(TEST2);6. 如何IMP帶有CLOB類(lèi)型字段的表? IMP USER/PASSWORD FILE=A.DMP FULL=Y;7. 從哪個(gè)版本開(kāi)始支持CLOB,BLOB等大字段? 8.0以上測(cè)試環(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.連線(xiàn)到: 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 個(gè)資料列.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ù)...