One of the operations of the Oracle large data type CLOB

Oracle
One of the operations of the Oracle large data type CLOB

Author: ccbzzp


When it comes to Oracle, it is possible to use a large number of types of operations, in which I simply sum up, I hope to help you! Also welcome everyone to explore together, in order to progress together, together development!
This article is not for Oracle's master to see.

1. How do I create a table with Clob types of fields?
CREATE TABLE TEST2 (AAA CLOB);

2. How do I add a record to a table with a CLOB type of field?
INSERT into TEST2 VALUES (' Ccbzzpccbzzp ');

3. How do I select a table with CLOB type fields?
SELECT * from TEST2;
SELECT * from TEST2 WHERE Dbms_lob. INSTR (TEST2. AAA, ' B ', 1,1 >0;

4. How to change table space for tables with CLOB type fields?
ALTER TABLE TEST2 move tablespace USERS;

5. How do I exp a table with CLOB type fields?
EXP User/password file=a.dmp tables= (TEST2);

6. How can imp take a table with Clob types of fields?
IMP User/password file=a.dmp full=y;

7. From which version to start to support Clob,blob and other large segments?
8.0

The above test environment is ORACLE92

Sql*plus:release 9.2.0.1.0-production on Thursday September 4 12:02:00 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connections to:
Oracle9i Enterprise Edition Release 9.2.0.1.0-production
With the partitioning, OLAP and Oracle Data Mining options
Jserver Release 9.2.0.1.0-production

sql> DROP TABLE TEST2;
DROP TABLE TEST2
*
ERROR row 1:
ORA-00942: Table or view table does not exist


Sql> CREATE TABLE TEST2 (AAA CLOB);

A table has been established.

Sql> INSERT into TEST2 VALUES (' Ccbzzpccbzzp ');

1 data columns have been established.

Sql> SELECT * from TEST2;

Aaa
--------------------------------------------------------------------------------
Ccbzzpccbzzp

Sql> SELECT * from TEST2 WHERE Dbms_lob. INSTR (TEST2. AAA, ' B ', 1,1 >0;

Aaa
--------------------------------------------------------------------------------
Ccbzzpccbzzp

Sql> ALTER TABLE TEST2 move tablespace USERS;

The table has been changed.

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 exported
Export terminated successfully without warnings.

sql> drop table test2;

The table has been erased.

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 imported
Import terminated successfully without warnings.


To continue ...