前几天就有同事问,long太难控制,想用varchar2,想想应该没问题。无独有偶,今天看论坛有同样的问题,那么做个测试,结果是需要把long借clob中转一下。
完整的测试过程如下:
SQL> select * from a01;
COL1 COL2 COL3
-------------------- ---- --------------------------------------------------------------------------------
1 1 wwwww
SQL> desc a01
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
COL1 VARCHAR2(20) Y
COL2 VARCHAR2(2) Y 'Y'
COL3 LONG Y
SQL> select * from a01;
COL1 COL2 COL3
-------------------- ---- --------------------------------------------------------------------------------
1 1 wwwww
SQL> update a01 set col1 = col3;
update a01 set col1 = col3
ORA-00932: inconsistent datatypes: expected NUMBER got LONG
SQL> select dump