Hacker News new | ask | show | jobs
by wfriesen 2979 days ago
In Oracle this is kind of hidden away since it is case sensitive, but unquoted identifiers are silently converted to uppercase, quoted identifiers are used as-is. So, for queries against something like

  create table foo (
    Bar integer,
    "Foobar" integer
  );
Referring to Bar, BAR, bar, and "Foobar" will work, but foobar and Foobar will not.