Case sensitive object naming in PL/SQL



The most important drawback of using quoted notation (like: "Employees") is that there's no check for reserved words. You could have a table called "ORDER BY hiredate DESC", or a column called "SELECT whEre from", a date column called "DATE"...

So I'd rather have the conventional naming.

You say that it is a drawback - but I might not agree (although I see your point).
If you start using case sensitive naming - stick with it. That is the same for variable naming, etc. - once you have a direction - keep on going there.
If I remember correctly then Oracle has some pseudo views with a columns like "NAME" or "TYPE". Although this is colored in Oracle SQL Developer and it is a reserved keyword... Is it good then?