Error creating SQL Command - Database Expert
I am creating a command however when I go to save the SQL I get two errors.
"Failed to retrieve data from database" and "Failed to execute SQL Statement"
I am working on an Oracle database.
Why would these errors be occuring?
if you are using orcale add command
Replace the following part "CI_SA_RS_HIST"."EFFDT"<date(2009,1,1) with
"CI_SA_RS_HIST"."EFFDT"<sysdate or "CI_SA_RS_HIST"."EFFDT"< TO_DATE('01-JAN-2009')