SQL> create table t (x long);
Table created.
SQL> insert into t values('asdarewhdfhsdkjfh');
1 row created.
SQL> commit;
Commit complete.
SQL> create table a (x clob);
Table created.
SQL> insert into a select to_lob(x) from t;
1 row created.
SQL> commit;
Commit complete.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7865774/viewspace-615449/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- SQL实现万年历
- Cannot Compile Forms Module On Unix FRM-91500
- 重新定位inventory
- CRS-215 Srvctl unable to start ASM, Listener, RDBMS Resources
- Abnornal program termination. An internal error has occured.
- 关于PRKC-1002问题的解决办法
- PRKC-1002错误
- No matching CACHE element found in webcache.xml for current hostname
- grep的一些例子
- 常用的分析函数
