Hi,
We have an application that in c# code automatically creates a query such as this;
SELECT
(KTOGR) AS [xval],
(round(sum(AU12 * -0.001),1)) AS [yval]
FROM Table
It works fine in SQL Server, but not in Oracle.
The problem seems to be AS [xval], where if we instead write;
AS xval
or
AS "xval"
then it works.
But we would like not to change the behavior of our c# code, if possible.
According to Oracle documentation [] is valid charaters in the select statement, but as it seems when we try it out - not in the "AS" part of the statement.
Is there some setting or similar in Oracle where it is possible to define that [] should work in the AS part of a select statement?
/Erik