Issue found :
http://forums.oracle.com/forums/thre...941753#3941753
bcaillet
Last Activity: Dec 3 '09, 10:46 AM
Joined: Oct 16 '09
Location:
-
Already done, data is the same.
My request is to engage officially with Oracle Support team, let me know if you can help.
Regards,
BertrandLeave a comment:
-
The issue is only with ORA 11g and the script provided is ORA indeed, not an SQL Server function.Leave a comment:
-
Oracle 11g code defect with Select SUBSTR funtion
Hi all,
A few weeks ago I posted a question about a potential defect in Oracle 11g. Today I have more details on the error.
Please contact me if you are an Oracle Support engineer, I will like to follow up directly.
The first Query 1 returns the correct value
SELECT SUM(t.debitmst) 270
FROM
(
SELECT
SUBSTR(nls_lowe r(ledgeraccount num), 1, 21) as account_substr,... -
The query returns null with Oracle 11g, not in Oracle 10g and SQL Server.Leave a comment:
-
Potential regression with Oracle 11g in Select Sum
Hi folks,
I need your expertise with Oracle. My application is using both SQL and Oracle. When testing the new release of Oracle 11g, one test case is failing and the following code is being regressed in ORA 11g from ORA 10g.
Does anybody if that's a known issue?
The code is
...Code:select sum(DEBITMST) from (SELECT SUM(A.DEBITMST) AS DEBITMST, SUM(A.CREDITMST) AS CREDITMST, SUM(A.DEBITOPRMST)
No activity results to display
Leave a comment: