Re: Query Error

From: Dan Blum <tool_at_panix.com>
Date: Fri, 1 Apr 2011 20:19:09 +0000 (UTC)
Message-ID: <in5bvt$5gj$1_at_reader1.panix.com>

The Magnet <art_at_unsu.com> wrote:
> Hi,

> I'm trying to use DBMS_METADATA to get the DDL:

> SELECT TO_CHAR(DBMS_METADATA.GET_DDL('TABLE',
> o.name,'DATA_HOLDER')) ddl_string
> FROM sys.obj$ o,sys.tab$ t
> WHERE o.owner# = 28
> AND o.obj# = t.obj#
> AND BITAND(o.flags, 128) = 0;

Why are you using TO_CHAR on it? You should be able to read the result without that.

-- 
_______________________________________________________________________
Dan Blum					         tool_at_panix.com	
"I wouldn't have believed it myself if I hadn't just made it up."

Received on Fri Apr 01 2011 - 15:19:09 CDT