Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- From: "Alberto Dell'Era" <alberto.dellera@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Thu, 10 May 2007 22:57:02 +0200
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@xxxxxxxxx> 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@xxxxxxxxxxx> 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.
-- //www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
Alberto Dell'Era
"dulce bellum inexpertis"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
