How to format output of dbms_metdata???

Dear All,

can some tell me how to format the output of dbms_metdata?

My output is as follows:

[/pre]
  CREATE INDEX "FINNBANKLEA"."LEA_AGREEMENT_DTL_IDX6" ON "FINNBANKLEA"."LEA_AGREEMENT_DTL" ("STATUS", "BRANCHID", "AGREEMENTID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING COMPUTE STATISTICS
  STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "FINNINDX" ;
[/post]

Also I used following setting:

[/pre]
set verify off
set echo off
set trims on
set linesize 1000
set heading off
set pagesize 10000
set long 500000
column Output format a1000
column XXXX format a1000

exec DBMS_METADATA.SET_TRANSFORM_PARAM (DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true) /

execute DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',true)
[/post]


Thanks in advance.

someone_geniusAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
there's no parameters for doing so.
You can do your own simple formatting with search and replace
of space with newline characters or something like that, but otherwise nothing.

There's really no need to format. The metadata output should be syntactically fine
0
 
someone_geniusAuthor Commented:
any comments friends.
0
 
AkenathonConnect With a Mentor Commented:
There are entire applications devoted just to formatting SQL, look into Quest's "SQL Formatter", which BTW comes with TOAD. It does a very good job and has lots of settings to let you choose capitalization, indentation, newline placement... moreover, it can optionally add warnings if it finds code that may have SEMANTIC problems!
0
 
Computer101Commented:
Forced accept.

Computer101
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.