dbms_metadata.set_transform_param 'PRETTY' option does not work
- From: "Binh Pham" <binhpham15@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 10 May 2007 17:59:41 +0000
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
- Follow-Ups:
- Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- From: Daniel W. Fink
- Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- From: Wolfgang Breitling
- Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- From: Niall Litchfield
- References:
- Re: dba_extents and dba_segments
- From: rjamya
Other related posts:
- » dbms_metadata.set_transform_param 'PRETTY' option does not work
- » Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- » Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- » Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- » Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
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.
- Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- From: Daniel W. Fink
- Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- From: Wolfgang Breitling
- Re: dbms_metadata.set_transform_param 'PRETTY' option does not work
- From: Niall Litchfield
- Re: dba_extents and dba_segments
- From: rjamya