本文介绍了Oracle/PLSQL中的to_nclob函数，它用于将LOB（Large Object）转换为NCLOB（National Character Large Object）。通过示例展示了如何在11g、10g和9i版本中使用此函数，如将suppliers表中的lob_column字段转换为NCLOB类型。
In Oracle/PLSQL, the to_nclob function converts a LOB value to a NCLOB value.
Syntax
The syntax for the to_nclob function is:
to_nclob( expression )
expression can be a char, varchar2, nchar, nvarchar2, clob or nclob value.
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i
For Example
select to_nclob(lob_column)
from suppliers;
This example would convert the value in the field called lob_column to an NCLOB value.
777
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
