You will be required to write data from Oracle Tables to a text file. This is around 3-4 days work and my budget for the project is around 100 GBP. This project needs to be completed within 7 days.
Detailed specifications and login to database will be provided but at a high following tasks will be needed.
1. Create unit tests plan
2. Prepare unit test data. This can be a subset of existing data in [login to view URL] just need to create update script to update markers/ flags of test data records
3. Write DDL queries. Essentially
4. Write stored procedure to do the following. Detailed specifications and pseudo code will be provided.
> Read data from an Oracle table
> write data to a File after writing a header record
3. Update status in table and error log tables
5. Execute and ensure all unit test pass. Provide before and after image of table and file created as evidence.
If required a stored procedure and unit test plan will be provided from another project that already does something similar but for other data type.