clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1044269 fiddles created (9440 in the last week).

-- -- -- Summary: in SQL-92 Standard unquoted identifiers are converted to uppercase -- -- Please try this for all databases and see which one follows the standard -- -- ISO/IEC 9075:1992, Database Language SQL -- -- http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt -- -- of course, any lower case letters appearing in a <regular identifier> will have -- been converted to the corresponding upper case letter before the <identifier> -- is stored in any table of the Information Schema -- -- every letter that is a lower-case letter replaced by the equivalent upper-case letter or letters create table a (a int);
 hidden batch(es)


create table A (A int) /* ERROR SQL-92 database should raise an error here because the previous one created an uppercase table name */;
ORA-00955: name is already used by an existing object
 hidden batch(es)


create table "a" ("a" int) /* OK SQL-92 database accept this because no lower case table has been created yet */;
 hidden batch(es)


create table `A` (`A` int) /* ERROR SQL-92 database should raise an error here because this is not an accepted quote */;
ORA-00911: invalid character
 hidden batch(es)


create table `a` (`a` int) /* ERROR SQL-92 database should raise an error here because this is not an accepted quote */;
ORA-00911: invalid character
 hidden batch(es)