Generate sample CDC data in Oracle
In Oracle, enter the following to generate CDC data:
INSERT INTO POSAUTHORIZATIONS VALUES('COMPANY 1', 'D6RJPwyuLXoLqQRQcOcouJ26KGxJSf6hgbu',6705362103919221351,0,'20130309113025','0916', 'USD',2.20,5150279519809946,41363,'Quicksand'); INSERT INTO POSAUTHORIZATIONS VALUES('COMPANY 2', 'OFp6pKTMg26n1iiFY00M9uSqh9ZfMxMBRf1',4710011837121304048,4,'20130309113025','0815', 'USD',22.78,5985180438915120,16950,'Westfield'); INSERT INTO POSAUTHORIZATIONS VALUES('COMPANY 3', 'ljh71ujKshzWNfXMdQyN8O7vaNHlmPCCnAx',2553303262790204445,6,'20130309113025','0316', 'USD',218.57,0663011190577329,18224,'Freeland'); INSERT INTO POSAUTHORIZATIONS VALUES('COMPANY 4', 'FZXC0wg0LvaJ6atJJx2a9vnfSFj4QhlOgbU',2345502971501633006,3,'20130309113025','0813', 'USD',18.31,4959093407575064,55470,'Minneapolis'); INSERT INTO POSAUTHORIZATIONS VALUES('COMPANY 5', 'ljh71ujKshzWNfXMdQyN8O7vaNHlmPCCnAx',6388500771470313223,2,'20130309113025','0415', 'USD',314.94,7116826188355220,39194,'Yazoo City'); UPDATE POSAUTHORIZATIONS SET BUSINESS_NAME = 'COMPANY 1A' where pos= 0; UPDATE POSAUTHORIZATIONS SET BUSINESS_NAME = 'COMPANY 5A' where pos= 2; UPDATE POSAUTHORIZATIONS SET BUSINESS_NAME = 'COMPANY 4A' where pos= 3; UPDATE POSAUTHORIZATIONS SET BUSINESS_NAME = 'COMPANY 2A' where pos= 4; UPDATE POSAUTHORIZATIONS SET BUSINESS_NAME = 'COMPANY 3A' where pos= 6; DELETE from POSAUTHORIZATIONS where pos=6; COMMIT;