Oracle PL/SQL Tutorial/Large Objects/LONG
Содержание
Copying LONG to LOB with the ALTER TABLE...MODIFY statement
<source lang="sql">
SQL> CREATE TABLE myLongTable1 (id NUMBER,long_data LONG); Table created. SQL> SQL> INSERT INTO myLongTable1 VALUES (100,RPAD("A",200000,"A")); 1 row created. SQL> SQL> ALTER TABLE myLongTable1 MODIFY (long_data CLOB); Table altered. SQL> SQL> drop table myLongTable1; Table dropped.</source>
Long raw type column
<source lang="sql">
SQL> CREATE TABLE myTable (
2 id INTEGER PRIMARY KEY, 3 long_raw_column LONG RAW NOT NULL 4 );
Table created. SQL> SQL> drop table myTable; Table dropped.</source>
long type column
<source lang="sql">
SQL> SQL> CREATE TABLE myLongTable (id NUMBER,long_data LONG); Table created. SQL> SQL> INSERT INTO myLongTable VALUES (100,RPAD("A",200000,"A")); 1 row created. SQL> SQL> drop table myLongTable; Table dropped. SQL></source>
Long type column, not null
<source lang="sql">
SQL> CREATE TABLE myTable (
2 id INTEGER PRIMARY KEY, 3 long_column LONG NOT NULL 4 );
Table created. SQL> SQL> SQL> drop table myTable; Table dropped.</source>