Insert char value to long type column
SQL> SQL> create table l 2 (c1 long); Table created. SQL> SQL> insert into l 2 values ('a'); 1 row created. SQL> SQL> commit; Commit complete. SQL> SQL> alter table l modify (c1 clob); Table altered. SQL> SQL> drop table l; Table dropped. SQL>