kdschool
asked on
oracle sql syntax help
oracle sql. I created a field using this trunc(sysdate) - trunc(EVENT_DT) as TotalDays, I have tried different things and none work. Can you help with syntax to do this?
In the where statement I want only get the days >10
and TotalDays > (10)
ORA-00904: "TOTALDAYS": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 40 Column: 5
In the where statement I want only get the days >10
and TotalDays > (10)
ORA-00904: "TOTALDAYS": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 40 Column: 5
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER