Re Re: Due apologies for DDLs

From: Cyril Thankappan <cyril_thank_at_rediffmail.com>
Date: Thu, 03 Jan 2002 22:58:11 -0800
Message-ID: <F001.003E6AB8.20020103223519@fatcity.com>

U r right ..I still dunno 'much' about perl..

as for dbms_metadata

it is a built in pl/sql package

saying

'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual;

gives the entire ddl creation script.

However, 'interestingly'
execute dbms_metadata.get_ddl does not work as well!

More interestingly metalink does not have much on it either.. I guess it works too well!!!!

Thanks

Cyril

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Cyril Thankappan
  INET: cyril_thank_at_rediffmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jan 04 2002 - 00:58:11 CST