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

On Fri, 01 Apr 2005 19:22:43 +0200, Noel interested us by writing:

>
> 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;

Ah - it now appears that you agree with my Method 1. Thanks for the clarification.

-- 
Hans Forbrich
Oracle training and consulting in Canada
mailto: Fuzzy.GreyBeard _at_ gmail.com   
    or: echo "News.Hans_at_Telus_NOSPAM.net" | sed s/_NOSPAM//g