When creating a View with the "WITH READ ONLY" clause and then opening it in the Editor, the "WITH READ ONLY" clause is no longer displayed.
Steps to Reproduce:
1. Create a view with READ ONLY constraint:
Example:
CREATE VIEW d (dummy )
AS
select dummy from dual WITH READ ONLY
/
2. Double-click on View in DB Explorer
Expected results:
Editor displays the complete SQL code for the View
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center