Double "Select" Keyword when view starts with comments (after Import From Designer) (Doc ID 1534414.1)

Last updated on JUNE 24, 2021

Applies to:

Goal

Free format view with select statement (in designer) imported incorrectly in data modeler.
The problem happens when the first line in the select statement is a comment-line.
How to deal with this kind of view definition.

E.g. view format view:
-- comment line
Select Deptno,
         Dname
From Dept;
 

Result:

Select
-- comment line
Select Deptno,
         Dname
From Dept;

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.