Oracle PL/SQL Tutorial/Large Objects/LONG

Материал из SQL эксперт
Перейти к: навигация, поиск

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>