获取具有默认值的参数列表
问题描述：
我使用ALL_ARGUMENTS来获取oracle 10g中的参数列表，但是我找不到参数的默认值.我能做到吗?
I use ALL_ARGUMENTS to get list of arguments in oracle 10g, but I can't find out is there default value for argument. Haw can I do it?
答
在视图SYS.ALL_ARGUMENTS中有一个名为DEFAULT_VALUE的列，但即使在11g中，它的类型也为LONG，解决和转换为CLOB.
In the view SYS.ALL_ARGUMENTS there is a column named DEFAULT_VALUE, but even in 11g it's type is LONG and is a headache to work around and convert to CLOB.
最简单"(不是最好)的方法是从该视图创建表，使用TO_LOB将该字段转换为CLOB并使用该表.
The "easiest" (not the best) way is to create a table from this view, using TO_LOB to convert this field to a CLOB and work with that.