Need expertise in Oracle SQL Stored Procedures/Jobs
$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.
Project ID: #17194934
About the project
45 freelancers are bidding on average $131 for this job
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
please come to the chat......................................................................................sfs.........................................
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?
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 More
Having 10+ year of Oracle development experience. I would able to provide better resolution of the problem.
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 doin More
HI, I can work on this query......................................................................................................................................... Regards, Aditi
Good day............. I am ready to do that ............. you will not lose your money............... regards
Yes I can put together an algorithm in PL / SQL to solve the problem, could you please give me the details about this?