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.
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.