Recent content by Ralph Slate

That isn't correct either -- that view only contains code-based source, not views. Ralph

This isn't correct. Try this yourself; create a view using CREATE VIEW... syntax. Then view the source in PLSD. You'll see the view start out CREATE VIEW ... Now create a view using CREATE OR REPLACE VIEW... syntax, and then view the source in PLSD. You'll see it says CREATE OR REPLACE VIEW...

Does anyone know how, in Oracle, those aliases are stored, and how PL/SQL developer knows when to use them? I have two views; one with column aliases before the SELECT clause, and one with them within the SELECT clause (my preferred syntax). Anything in the SELECT clause is stored in the TEXT...