Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

I tried to debug the same but unable to convert the below output to Date format 1/1/2017 10/1/2016 tried to_datetime function but no luck. is there any other way to do this .

in Inconsistent datatypes: expected NUMBER got CHAR at OCI call OCIStmtExecute Comment by Raghunandan Sep 23, 2021 2:19PM
Below is the physical query generated

in Inconsistent datatypes: expected NUMBER got CHAR at OCI call OCIStmtExecute Comment by Raghunandan Sep 23, 2021 7:11AM