Subject | Re: problem: PreparedStatement with "? IS NULL" |
---|---|
Author | ben_ata |
Post date | 2004-09-23T11:07:19Z |
--- In Firebird-Java@yahoogroups.com, "bullitenergy" <s.hahn@o...>
wrote:
usage of column identifiers (e.g. "MyTable" is a different table the
"MYTABLE" or event then MYTABLE) or if the table name contains
characters that aren't allowed in table names, or if the table name is
a reserved word (e.g. in Oracle you cannot create a table USER but you
can create a table "USER").
From my limited knowledge of the ANSI standard, I think this is how
the usage of quotes is specified there.
wrote:
> However i thought that using "quoted"AFAIK quoted identifiers should be used to indicate case-sensitive
> identifiers was in the SQL standard and [bracketed] identifiers are
> the MS-SQL and Access extension.
usage of column identifiers (e.g. "MyTable" is a different table the
"MYTABLE" or event then MYTABLE) or if the table name contains
characters that aren't allowed in table names, or if the table name is
a reserved word (e.g. in Oracle you cannot create a table USER but you
can create a table "USER").
From my limited knowledge of the ANSI standard, I think this is how
the usage of quotes is specified there.