How to convert CLOB to VARCHAR2 ?
来源:互联网 发布:xampp修改mysql密码 编辑:程序博客网 时间:2024/05/18 00:46
dbms_lob.substr can help you.
Tips & Warnings
The dbms_lob.substr function has three parameters: the field name, the number of characters you want to convert and the position from which the conversion begins. The expression, dbms_lob.substr( clob_field, 4000, 1 ) converts 4,000 characters of clob field beginning with the first. Use a smaller number in place of 4,000 if you want to convert fewer characters, and use a number larger than one to shift the starting point of the conversion.
- How to convert CLOB to VARCHAR2 ?
- How to Convert From Clob to Varchar2 in Oracle
- How to execute a query in varchar2 ?
- How to convert InputStream to String/convert char[] to String
- How to convert string to Guid type.
- How to convert a String to DateTime
- How to convert .mdf to .sdf
- How to convert PDF to XLS
- Java : how to convert text to image
- How to convert wchar_t* to char*
- How To Convert HTML Page To Image
- How to convert QString to std::string?
- how to convert UTC to local time
- Java: How to convert int[] to byte[]
- How to properly convert SecureString to String
- how to convert wstring to string
- How to Convert CER to DER
- how to convert char to char []
- layout_weight使用
- java url request参数解析类
- win7 vmware 安装mac os lion10.7
- Spring JPA
- Android的USB打印机部署
- How to convert CLOB to VARCHAR2 ?
- 个人博客的迁移
- oracle字符集笔记
- html5 drawImage图片不显示问题
- 获得通讯录中联系人的所有属性
- SQL条件的顺序对数据库性能的影响
- 开源三维GIS平台(引擎)笔记
- Oracle10g技术问题总结(二)控制台登录时出现Io 异常:Unknown host specified
- windows恢复刚刚删除的文件(已经清空回收站)