Re: displaying a view correctly.

Yes, i've set "long" to a high value but it puts the select statement of the view in one line in consecutive.
Example:

The views are stored in table fnd_views that looks like

Name                            Null?    Type
------------------------------- -------- ----
APPLICATION_ID                  NOT NULL NUMBER(15)
VIEW_ID                         NOT NULL NUMBER(15)
VIEW_NAME                       NOT NULL VARCHAR2(30)
LAST_UPDATE_DATE                NOT NULL DATE
LAST_UPDATED_BY                 NOT NULL NUMBER(15)
CREATION_DATE                   NOT NULL DATE
CREATED_BY                      NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN               NOT NULL NUMBER(15)
DESCRIPTION                              VARCHAR2(240)
TEXT                                     LONG

when you set long to 1500 (or whatever) it results in:

SELECT   L.LINE_ID LINE_ID , A.NAME ACTION , R.NAME RESULT ,
DECODE(A.RESULT_COL
UMN, 'S1', L.S1_DATE, 'S2', L.S2_DATE, 'S3',     L.S3_DATE, 'S4',
L.S4_DATE, 'S5


', L.S5_DATE, 'S6', L.S6_DATE, 'S7',     L.S7_DATE, 'S8', L.S8_DATE,


'S9', L.S9_


DATE, 'S10', L.S10_DATE,     'S11', L.S11_DATE, 'S12', L.S12_DATE,


'S13', L.S13_


............   bla bla bla ....FROM
........................................................ 

My question was if there is any way (outside of copy paste to text document and do it by hand) to see the query on a proper way, p.e. as:

SELECT   L.LINE_ID LINE_ID , 
         A.NAME ACTION , 
         R.NAME RESULT , 
         ............................   bla bla bla bla.....
FOM      .............
WHERE    ................

That was my question. Is this possible ?

Best regards and thanks on advance.

Ronald. Received on Thu Oct 02 2003 - 15:26:58 CEST