Oracle Golden Gate extract date format [message #658075] |
Fri, 02 December 2016 08:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dev_sri
Messages: 4 Registered: July 2008 Location: Hyderabad
|
Junior Member |
|
|
Team,
we are currently facing initial load issues and need to filter data depending on date criteria :
TABLE SCH_CAT15.EMPLOYEE, SQLPREDICATE 'WHERE TRAN_DATE BETWEEN '31-JAN-15' AND '25-FEB-15'';
Can anyone please provide suggestions on how to provide exact filter conditions.
Rgds,
Sri
|
|
|
|
Re: Oracle Golden Gate extract date format [message #658102 is a reply to message #658075] |
Sat, 03 December 2016 14:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
dev_sri wrote on Fri, 02 December 2016 06:20Team,
we are currently facing initial load issues and need to filter data depending on date criteria :
TABLE SCH_CAT15.EMPLOYEE, SQLPREDICATE 'WHERE TRAN_DATE BETWEEN '31-JAN-15' AND '25-FEB-15'';
Can anyone please provide suggestions on how to provide exact filter conditions.
Rgds,
Sri
CREATE VIEW would be how I do it.
|
|
|