Preserve comments when compiling

[Remo Laubacher]

Hi

I have a simple question: When I recompile a view I'm loosing all comments. Because comments are really important for us I always have to add the after compiling..

Is it possible to presve comments when compiling?

Thanks
Remo

 

[Marco Kalter]

This is on the list of enhancement requests.

 

[Remo Laubacher]

Are there any news according to that enhancement request?

Thanks
Remo

 

[LMW]

Hello Remo,

the comments will be stripped by Oracle not by PSD.

But you will not lose your comments in views, if you place them behind the "select" - Keyword

e.g.
--Comment that will be stripped
CREATE OR REPLACE VIEW TEST
--Comment that will be stripped
AS
--Comment that will be stripped
SELECT
--Comment that will NOT be stripped
*
--Comment that will NOT be stripped
FROM dual
--Comment that will NOT be stripped

Wilhelm