Nov 212012
 
create table you_are_all_individual_columns (
  yes_we_are_all_individuals   integer ,
  "Yes_We_Are_All_Individuals" integer ,
  "yes_we_are_all_individuals" integer ,
  "YES_we_ARE_all_individuals" integer ,
  "yes_we_are_ALL_individuals" integer ,
  "yes_we_are_all_InDiViDuAlS" integer ,
  "yeS_wE_arE_alL_individualS" integer ,
  im_not xmltype 
);

Thanks to a post from Charles Hooper and the ever brilliant Life of Brian for providing inspiration for this.

If you enjoyed this article, Get email updates (It’s Free)

  2 Responses to “Yes, these really are different columns”


  1. sokrates > create view user_isnt_user("USER")
    2 as
    3 select 'Sokrates' from dual;

    View created.

    sokrates > select USER, "USER" from user_isnt_user where "USER" != USER;

    USER USER
    ------------------------------ --------
    SOKRATES Sokrates

    • Things like that make my head hurt! ;)

      Kind of shows it’s a bad idea to name your columns the same as reserved Oracle words.

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>