Change column type from long to clob : Long « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. Long

Change column type from long to clob

  

SQL>
SQL>
SQL> create table myTable (c1 long);

Table created.

SQL>
SQL> insert into myTable values ('a');

1 row created.

SQL>
SQL> commit;

Commit complete.

SQL>
SQL> alter table myTable modify (c1 clob);

Table altered.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL>








Related examples in the same category

1.Set long: query a table or view that has a LONG column
2.Demonstrate a method of converting to a LONG column to CLOB:
3.Conversion of Longs to LOBs
4.Insert char value to long type column
5.Long raw type column
6.Long type column