Need expertise in Oracle SQL Stored Procedures/Jobs

$30-250 USD

Completed

Posted

almost 6 years ago

$30-250 USD

Paid on delivery

HI I have a requirement and a query with me but need to run that query to show data as it ran on last Tuesday of each month for past 12 months. So for current month the logic should be as follows: When the query runs on 5 Jun 18 (1stTuesday of current month) it should store the value against month column Jun'18 as say "a" when the query runs on 12 Jun 18 (2ndTuesday of current month) it should replace the value "a" from above with whatever value is obtained then say "b" when the query runs on 19Jun 18 (3rdTuesday of current month) it should replace the value "b" from above with whatever value is obtained then say "c" when the query runs on 26 Jun 18 (4thTuesday of current month) it should replace the value "c" from above with whatever value is obtained then say "d" Once it reads the 4th Tuesday as last Tuesdayof the month in this case it should retain it's value "d" Later for next Tuesday it needs to create another month column say July and follow the same steps as above. Let me know of you can get this done so I can share more details on this later.

Database Administration

Database Programming

Oracle

SQL

Project ID: 17194934

About the project

45 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@vaidyag

HI, I have excellent experience in database programming. I have worked on various databases like Oracle, MYSql, Sql. I have worked on various projects like tuning, writing complex queries , or working on full fledged BI / Analytics projects I have worked in Infosys a top IT services company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been working with Microsoft as customer delivering projects in MS technologies. Will be able to leverage this experience to deliver this project successfully. Thanks Regards Vaidy

$155 USD in 3 days

5.0

(12 reviews)

5.0

45 freelancers are bidding on average $131 USD for this job

@hits

We have expertise in Oracle SQL Stored Procedures/Jobs. I have read through the requirements and am confident of delivering as needed. I had a query, why store each Tuesday's data to be only overwritten by subsequent Tuesday's data and when we store only last Tuesday's data for future reference. Please share sample data and details. I am sure that will explain. It will also help me to assess scope of work precisely. I will revise / confirm my bid accordingly. Detailed specifications and inputs will also help me to make an informed commitment and deliver as required. I ensure a very thorough job and also support if you need changes / enhancements in future. I look forward to hearing from you and working on the project.

$250 USD in 4 days

4.9

(66 reviews)

6.9

@sreenivas2903

I am expertise in writing queries and proc's , ping me your schema related info , i will finish this and let you know, hope you would like to work more after this job

$111 USD in 3 days

4.9

(14 reviews)

4.3

@ref2

Hi I have 15+ years of experience in developing applications on oracle database. I have bachelor degree in cs, 25 oracle certified trainings and web app dev certificate from University in Chicago. Currently I support few application for api and batch processing using plsql procedures for about 2 milion transactions daily. I will be glad to work for you on this project. Regards

$133 USD in 3 days

4.8

(26 reviews)

4.4

@itbarduga

Hello, Myself Barduga, I have expertise in Oracle SQL and PLSQL development. I could help you in achieving the task which you are looking for. One question: There are chances that there could 5 Tuesdays in a month. How have you thought of handling this. Please feel free to discuss with me. Warm Regards Barduga

$70 USD in 3 days

5.0

(9 reviews)

3.8

@donovan6

Hi, I'm an Oracle DBA/Programmer with over 51 years experience. Yes I can make this work using a PL/SQL stored procedure or package depending on the complexity of the data. I'd need more details to decide on the best approach.

$133 USD in 3 days

5.0

(2 reviews)

3.5

@OWDGroup

Hi, I'm a database architect and programmer having more than 15 years of experience with different types of domains like telecom, banking, payroll, crm, ecommerce etc with high data volumes and I'm experienced with oracle and ms-sql and also experienced with ssis. Please contact me for more and request you to share table details with relational mapping document(if any). Cheers!

$98 USD in 5 days

4.5

(5 reviews)

3.2

@ihshsl

please come to the chat......................................................................................sfs.........................................

$100 USD in 3 days

3.8

(2 reviews)

2.1

@nnesarikar

Hello...I have over 12 years of experience in Oracle DB and I can make this happen in quick time. Is this a one time requirement or do you have such recurring requirements?

$166 USD in 3 days

5.0

(1 review)

1.6

@evlfilonenko

13 years experience with Oracle (IT in banking) This work can be done very quickly

$155 USD in 3 days

0.0

(0 reviews)

0.0

@techbluesoft6

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"

$155 USD in 3 days

0.0

(0 reviews)

0.0

@VISITNKS

Having 10+ year of Oracle development experience. I would able to provide better resolution of the problem.

$250 USD in 3 days

0.0

(0 reviews)

0.0

@vhani22

I am very responsible and with a good work ethics. Highly involved in different business process improvements and automations that improved company’s Operations Level of Agreement and increased Stakeholders satisfaction ratings following Agile Methodology. Exceptional customer care professional who addresses inquiries and resolves problems as they arise. ITIL V3 Certified ensures of the key elements, concepts and terminology used in the ITIL® service lifecycle. Good oral and written communication skills. Strong analytical, teamwork and customer engagement skills. Ability to learn about new systems and equipment quickly Demonstrated ability to work under pressure. Ability to multi-task, adapt to change, and achieve results with accuracy and precision Excellent Time Management Skills. Process Improvement Specialist. Adherence to high Customer Service Standards Productive, self –starter with a strong work ethics; Customer-Focused consistently achieve goals

$155 USD in 3 days

0.0

(0 reviews)

0.0

@sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012, 2) MYSQL, MS Access 3) Oracle (PL/SQL), 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS.

$155 USD in 3 days

0.0

(0 reviews)

0.0

@adisapsystem

HI, I can work on this query......................................................................................................................................... Regards, Aditi

$155 USD in 3 days

0.0

(0 reviews)

0.0

@eze1280

Hi, My name is Ezequiel I'm a Sr .NET/Oracle Developer. Do you want to build a batch? do you have a unix job that executes on every tuesday? Just need to fit the query? Please let me know more details so I can make a better bid. Atte. Ezequiel Silvestro

$55 USD in 10 days

0.0

(0 reviews)

0.0

@hisajeed

Hi, I understand that you are looking to get the result of each execution of the SQL (on Tuesdays). for clarity of requirements, could you provide more details for questions below: 1. Are you looking to store the result in a csv file 2. Is the SQL query scheduled to automatically run through some tool or scheduler? if yes, please provide the name of tool or scheduler 3. it will be great if you have a sample template of how you want the final data to look like. For e.g., with a sample of 1 or 2 rows of result data and format that you want data to look for a month (say for 4 Tuesdays). If not available, I can work with you to make a format/ template that works for you after you accept my bid. 4. if you accept my bid, I would also need the table structure to test my code and ensure it works perfectly 5. I can even suggest any indexes that can improve the performance of the SQL Thanks Sajeed

$100 USD in 3 days

0.0

(0 reviews)

0.0

@bhautik10

I have experience of working with database like Oracle, Sql Server. Handle large volume of data and develop MIS reports as per requirement. Proficient in writing SQL Queries, Stored Procedures & Views, creating Crystal Reports 12+ Years of Experience in Development of Desktop / Web applications. Hands-on Programming Experience in full life-cycle projects using .NET Technologies and Oracle/Sql Server database.

$125 USD in 3 days

0.0

(0 reviews)

0.0

@haithambayoud

Good day............. I am ready to do that ............. you will not lose your money............... regards

$155 USD in 3 days

0.0

(0 reviews)

0.0

@analistaplsql

Yes I can put together an algorithm in PL / SQL to solve the problem, could you please give me the details about this?

$88 USD in 3 days

0.0

(0 reviews)

0.0

@vkvtech

Hi Here is the draft of script you needed: DECLARE tuesday_no NUMBER (1); is_tuesday_now NUMBER (1); BEGIN SELECT CASE WHEN TO_NUMBER (TO_CHAR (SYSDATE, 'D')) = 5 THEN 1 ELSE 0 END CASE, TRUNC (TO_NUMBER (TO_CHAR (SYSDATE, 'DD')) / 7) + 1 INTO is_tuesday_now, tuesday_no FROM DUAL; UPDATE your_table SET your_field = DECODE (tuesday_no, 1, 'a', 2, 'b', 3, 'c', 4, 'd', '?' ); END; I can make it in one query if needed. But I would like to get more details. Looking forward to continue. Constantine

$30 USD in 10 days