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

From: Noel <tbal_at_go2.pll-l>
Date: Fri, 01 Apr 2005 15:29:06 +0200
Message-ID: <d2jibo$e5e$1@inews.gazeta.pl>

Użytkownik HansF napisał:
> On Fri, 01 Apr 2005 04:44:53 -0800, aaa interested us by writing:
>
>

>>I tried to list all tables under user's schema use
>>"dbms_metadata.get_ddl" but fail.  Does anyone know
>>how to do it?
>>SQL> select dbms_metadata.get_ddl( 'TABLE',,'USER1')
>>from dual;
>>select dbms_metadata.get_ddl( 'TABLE',,'USER1') from
                                      ^^^^^^^
>>dual

>>ERROR at line 1:
>>ORA-00936: missing expression

> Method 1:
>
> Create a loop on USER_TABLES, run the select specifying the table name as
> parm 2.
>
> Method 2:
>
> Use the sample code provided in the manual
>

Method 3:

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

-- 
Noel

Received on Fri Apr 01 2005 - 07:29:06 CST