I have a view that was created with column aliases. When I view the source of this view in PL/SQL Developer, I don't see the column aliases. However, the view does return the aliased columns when data is selected. This is very confusing when using the tool.
Example of Real Source for View:
CREATE OR REPLACE VIEW TEST(test1) AS
SELECT Name
FROM MyTable
WITH READ ONLY
Example of Source Shown in Pl/Sql Dev for View:
CREATE OR REPLACE VIEW TEST AS
SELECT Name
FROM MyTable
WITH READ ONLY
After looking in the newsgroup, I see a similar post from last year titled "View Column Aliases Lost." It said it would be fixed a long time ago, but it apparently still hasn't been fixed.
Example of Real Source for View:
CREATE OR REPLACE VIEW TEST(test1) AS
SELECT Name
FROM MyTable
WITH READ ONLY
Example of Source Shown in Pl/Sql Dev for View:
CREATE OR REPLACE VIEW TEST AS
SELECT Name
FROM MyTable
WITH READ ONLY
After looking in the newsgroup, I see a similar post from last year titled "View Column Aliases Lost." It said it would be fixed a long time ago, but it apparently still hasn't been fixed.
