Renaming the columns and calculations in the result set page 3 |
||||||||
MySQLThe query
I can explain this behaviour by default settings which adopt usage of
double quote symbol (") in the same manner as single quote (') - for
delimiting the character constant. So two string unites into one string.
However if you type the query as
To forbid usage of double quote as single quote, you can replace settings by standard ones. The following statement changes the setting mentioned above:
After that the query
Oracle & PostgreSQLThese DBMS behave in standard manner. Note only that Oracle (in view of FROM clause is mandatory) demands to rewrite our query as
|