- Develop 6 stored procedures for demo:
- Create/Update/Get/List/Delete/Reset account/s information
ACCOUNT-ID VARCHAR(12) CUSTOMER-ID VARCHAR(16) CUSTOMER-NAME VARCHAR IBAN VARCHAR(32) Country-Code VARCHAR(3) BANK-ID VARCHAR(4) BRNCH-ID VARCHAR(9)
Reset should delete the table and insert 10 static account information Account id should be unique, and created automatically if not specified in create
Need to create stored procedure in: Oracle, DB2, Sybase, MSSQL We will provide DB instances to work on.
Need a DBA/developer experienced in all of the above.
(will need later similar examples for insurance policy).