En cours

Oracle PL/SQL stored procedure write data to file

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 [url removed, login to view] 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.

Compétences : Oracle, SQL

en voir plus : writing unit tests, writing to a file in c, writing a procedure, subset test, sql oracle pl sql, sql in pl sql, sql code oracle, pseudo writing, pseudo code in oracle, procedure sql oracle, procedure pl sql oracle, procedure oracle pl sql, procedure in pl sql oracle, pl sql in oracle, pl sql and oracle, pl sql and, oracle sql pl, oracle header, my sql create database, if oracle pl sql

Concernant l'employeur :
( 1 commentaire ) Hitchin, United Kingdom

Nº du projet : #6422553

Décerné à:

ivanzuna

Greetings! I really need this job, please give me a chance. I bid on low price because this is my first work here. I am oracle database developer in erste bank and web application developer. You can look at my port Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% GBP en 4 jours
(0 Commentaires)
0.0

49 freelance font une offre moyenne de £124 pour ce travail

truongnguyen86

Hi there, I'm expert on oracle, actually I've done a work to pull out the data to a file, I use the util directory, pls share more your requirements. Waiting for your feedback. Thank you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(105 Commentaires)
6.0
eperfections

Dear Sir, I have expertise in oracle database and also can write test cases. Please provide me database access and also sample unit cases. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(80 Commentaires)
6.1
Reza2012

Hi I have more than 10 years experience in Oracle Database Administration and PL/SQL programming. Please see my profile. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(33 Commentaires)
4.9
smshafiqulislam

Hi, First of all thanks of such job posting. I am oracle certified developer and dba with more than 6 years of experience. Presently holding DBA positions in a multinational corporate as well as 2 offsite companies of Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(23 Commentaires)
5.0
acronymsolutions

Hi, I have gone through your requirements, I am 10+ years of experienced resource at CMMI -5 level company. Skill Set :- Operating Systems :Windows ,UNIX, Linux/Oracle Linux, HP-UX Languages : C, P Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(29 Commentaires)
5.5
BhargavaB

Hi this is bhargava expert in sql and pl/sql . i am ready to provide quick and efficient solution . ii am good in writing Automated unit test cases .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(19 Commentaires)
4.0
swarm22

Dear Sir, I have +5 year experiences in Oracle Database Development (PL/SQL). To Provide Quality, Modular , Result Oriented Work. Thanks & Regards HGDumaswala

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(3 Commentaires)
2.8
noorzaman1984

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(2 Commentaires)
0.9
grundahl

Hi, I'm an expert DBA working for big companies in France. I can do your job efficiently and provide only best quality work. The material ( stored procedure/unit test plan) that you already have can be usueful to Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(1 Évaluation)
1.0
ambrish2

I have 3 years experience with oracle pl sql. Kindly send me the detailed specs and i can start writing the unit test plan and once approved by you we can start coding part.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)
0.0
mndata

Hi, This project is well within my skillset. I have done similar projects in the past, reading and writing from oracle to / from csv files via pl/sql. I'm currently employed as a Data Warehouse consultant in NZ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)
0.0
dibash15487

Ø 4+ years of progressive experience in software development using Oracle SQL, PL/SQL and UNIX. Ø Good exposure to Software Development Life Cycle following Waterfall methodologies. Ø Well conversant in translating b Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
shaifkamra

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
gak0609

Hello, How are you. The Project you have posted is a close match to my skill set, hence I am providing a proposal along with the bid. About Me: I am an Oracle Certified Professional, having 7 years of experienc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
FDTConsulting

Dear I'm an experienced database developer and administrator, used to deal with any kind of projects and to solve any kind of problems linked to database development, sql tuning and database tuning. I have all the Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)
0.0
cic100coco

Hi, I have +4 years experience with SQL and PL/SQL. I have created packages, procedures for different systems. Regards, Cosmin

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)
0.0
sivasasikumar

Hi, I seen your requirements, i think i am very much comfort for this work, i have an expert in DDL Queries, Pseudo code, Stored Procedure and Unit test so, i am ready to do this work with perfect. If you are comfort Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)
0.0
ramakrishna463

- Nearly 5 years of Industry experience as a Oracle Technical Consultant. - Very well Experienced in skills SQL,PL/SQL,Unix,Reports,Forms,BI Publisher - Good communication, has experience in dealing with UK Clie Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
him152311

Having 5 years of experience as oracle PL/SQL consultant \An Oracle Manufacturing Consultant and has working knowledge and expertise with BOM, WIP and other Supply Chain Module in Oracle Applications . He has work Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
hunter4746

I have been working as Oracle developer for past 8 years in Ireland for major banks. I have developed lot of applications for my clients in past 8 years. The reason i should be selected is because i have knowledge of Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)
0.0