I am loading the data from a VIEW which is created in SQL but WHERE condition is not working.
SELECT * FROM NEWC."VIW_MONTHLY" WHERE CALLDATE>='01/01/2013 00:00:00';
condition is not working im getting all 2010 data also. Kindly help me...
Select * from NWEC."VIW_MONTHLY" where CALLDATE >= '01-Jan-2013';
No it is not working it pulling all 2010 records also. this field contains Date & Time also.
Try to do this in QVW i.e after making Qvd of this query ,fetch this qvd in new qvw and apply this where condition w.r.t to date format that is fetched from qvd.
But whole data cant be fetch because the VIEW dont have WHERE clause so it will pull everything from database and database contains records from 2010. for one month only data will be 80-90k records.
Then fetched the whole data for one time and then put it to incremental load.
This has to done in daily basis so it is not possible
Select * from NWEC."VIW_MONTHLY" where to_date(CALLDATE,'DD-Mon-YYYY') >= '01-Jan-2013';
It is giving for this query...
ErrorSource: OraOLEDB, ErrorMsg: ORA-01843: not a valid month
Select * from NWEC."VIW_MONTHLY" where CALLDATE >= to_date('01-Jan-2013' ,'DD-MON-YYYY')
ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string
What is the version of your Oracle?
Select * from NWEC."VIW_MONTHLY" where CALLDATE >= to_date('01-JAN-2013 12:00:00','DD-MON-RRRR HH24:MI:SS')
Retrieving data ...