SOA Database Adapter experiment
Hey, Here I am going to create a Database user which can be used for demonstrate the database adapter. grant connect, resource to soademo identified by soademo; create a table CREATE TABLE CREDITCARDINFO ( SSN VARCHAR2(15) NOT NULL, FIRST_NAME VARCHAR2(30), LAST_NAME VARCHAR2(30), CCNUMBER VARCHAR2(20) NOT NULL, CREDITRATING NUMBER, STATUS VARCHAR2(20) NOT NULL ); create a Table using XE Apex tool Insert records in to table Now, lets do insert operation on the table that was created following records for testing purpose insert into CREDITCARDINFO VALUES ( '111-11-1111', 'Neena', 'Kochhar', '1234-1234-1234-1234', '3' , 'VALID' ); insert into CREDITCARDINFO VALUES ( '222-22-2222', 'Steven', 'King', '5678-5678-5678-5678', '4' , 'VALID' ); insert into CREDITCARDINFO VALUES ( '333-33-3333', 'Lex', 'Devarakonda...