We are on PLSQL Developer release 9.0.3.1641.
We have a view that we use to create readable column headings for spreadsheet exports. One of the column labels in the view contains an apostrophe. The view compiles without error:
CREATE VIEW userfriendly AS
SELECT t.col1 "My Column"...