Re: how to list all table info use dbms_metadata.get

From: HansF <News.Hans_at_telus.net>
Date: Fri, 01 Apr 2005 15:08:32 GMT
Message-Id: <pan.2005.04.01.16.10.15.826796@telus.net>

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!

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

Received on Fri Apr 01 2005 - 09:08:32 CST

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