Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_metadata.set_transform_param 'PRETTY' option does not work

Re: dbms_metadata.set_transform_param 'PRETTY' option does not work

From: Alberto Dell'Era <alberto.dellera_at_gmail.com>
Date: Thu, 10 May 2007 22:57:02 +0200
Message-ID: <4ef2fbf50705101357v3c7651deo80c862fad8c6aba5@mail.gmail.com>


I've always wondered why Oracle doesn't open the source of dbms_metadata (or dbms_xplan, tkprof, etc). This would trigger a lot of people into making their own mods/forks, that Oracle could then pick and merge into the "official" trunk for free (if they were GPL'ed). At the very least - bugs would be noticed and corrected by the community, again for free.

On 5/10/07, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> Hence the saying beauty is in the eye of the beholder :)
>
> I find that you tend to get prettier output by also excluding the other
> details like storage clauses etc etc. More to the point since you are using
> apps you can use eTRM for this sort of stuff. Your object should be at
> https://etrm.oracle.com/pls/trm11510/etrm_fndnav.show_object?n_appid=200&n_tabid=15095&c_type=VIEW
> (metalink login required) and if I've got the version wrong you can use
> http://etrm.oracle.com/pls/etrm/etrm_search.search .
>
> cheers
>
> Niall
>
>
> On 5/10/07, Binh Pham <binhpham15_at_hotmail.com> wrote:
> >
> >
> >
> >
> >
> > I issue these statements:
> >
> > SQL> execute
> DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'PRETTY',true);
> >
> > SQL> select
> dbms_metadata.get_ddl('VIEW','AP_TAX_LINES_SUMMARY_V','APPS')
> from dual
> >
> > The output does not look PRETTY at all.
> >
> > Does it only work with certain object types? This is the description of
> the option:
> >
> > PRETTY (all objects) - If TRUE, format the output with indentation and
> line feeds.
> > Defaults to TRUE.
> >
> > Thanks.
> > ________________________________
> Catch suspicious messages before you open themówith Windows Live Hotmail.
> -- http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

-- 
Alberto Dell'Era
"dulce bellum inexpertis"
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 10 2007 - 15:57:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US