Re: how to list all table info use dbms_metadata.get_ddl????

From: Noel <tbal_at_gie_o_2.pl>
Date: Fri, 01 Apr 2005 19:22:43 +0200
Message-ID: <d2k023$n6h$1@inews.gazeta.pl>

Użytkownik HansF napisał:
> On Fri, 01 Apr 2005 15:29:06 +0200, Noel interested us by writing:

>>Method 3:
>>
>>Read error message cerefully.
>>Remove ',' from statetment :)

>
>
> Sometimes I am very slow to catch on. Please help me by explaining this
> one a bit more ... Do you mean, rewrite the statement to be
>
> select dbms_metadata.get_ddl( 'TABLE','USER1')
> from dual;
>
> ?? If that is what you meant, would that not pass 'USER1' as the object
> name, since the positional API (from the manual) is
>
> DBMS_METADATA.GET_DDL (
> object_type IN VARCHAR2,
> name IN VARCHAR2,
> schema IN VARCHAR2 DEFAULT NULL,
> version IN VARCHAR2 DEFAULT 'COMPATIBLE',
> model IN VARCHAR2 DEFAULT 'ORACLE',
> transform IN VARCHAR2 DEFAULT 'DDL')
> RETURN CLOB;
>
> I'm sooo confused!

Error said, there is syntax error.

Ok, i didn't check parameters.
It should be like this:

select dbms_metadata.get_ddl( 'TABLE','TABLE_NAME', 'USER1')

   from dual;

-- 
Noel

Received on Fri Apr 01 2005 - 11:22:43 CST