Tamamlanmış

Need expertise in Oracle SQL Stored Procedures/Jobs

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.

Beceriler: Veri Tabanı Yönetimi, Veritabanı Programlama, Oracle, SQL

Daha fazlasını gör: Hi...I need a website for a conference. Site should have parallax scrolling and be responsive, and work well on mobile and deskt, Hi. I am in need of driving traffic to my client\ s site , Hi, I need a creative logo for a new concept called \ LiveShop\ . It\ s basically a live FaceTime or Skype call from a retail st, hi i need logo for my company, hi i need to do a keygen for my software, hi i need to configure freepbx and asterisk upon a project we have really quick and easy stuff thanks, hi i need someone to take a list of 115 names and addresses that are currently in word and move them into, hi i need amazon listing, hi i need a logo for a kids toys realted business, hi - i need someone to take a list of ~115 names and addresses that are currently in word and move them into, classic asp sql stored procedures, list stored procedures oracle sql plus, sql stored procedures xml, sending email ms sql stored procedures, php sql stored procedures, work sql stored procedures attendance, search sql stored procedures, sql stored procedures table input, access sql stored procedures silverlight beta, sql stored procedures tutorial, writing sql stored procedures, convert sql stored procedures oracle, experience sql stored procedures, sql stored procedures minutes, run stored procedure oracle sql 2005

İşveren Hakkında:
( 1 değerlendirme ) Charlotte, United States

Proje NO: #17194934

Seçilen:

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 f Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 155%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(7 Değerlendirme)
4.4

Bu iş için 49 freelancer ortalamada $135 teklif veriyor

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 subseque Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(66 Değerlendirme)
6.9
truongnguyen86

Hello there, i'm expert on Oracle procedure, let me help you with this. With this requirement, for now i can think a solution like this: with to_char function we can know the date is which weekday(mon,tue,...) and with Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(164 Değerlendirme)
6.6
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 supp Daha Fazla

in %bids___i_period_sub_35% gün içinde133%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(25 Değerlendirme)
4.4
in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(21 Değerlendirme)
4.1
in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.6
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 mon Daha Fazla

in %bids___i_period_sub_35% gün içinde70%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.7
TSPSInc

Full stack developer with 30+ years experience I read your description but you didn't mention which version of Oracle you are using so I created a example using Oracle [login to view URL] I create a table called Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
3.7
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde133%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
3.2
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

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
3.1
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 or Daha Fazla

in %bids___i_period_sub_35% gün içinde98%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
2.5
Cognegic

Dear Sir, Greeting of the day! I am a result-oriented professional with over 11+ years of experience on big data components, architecture, developments, Oracle, PostgreSQL, PL SQL, MS SQL, NO SQL, MySQL, SQL, Ha Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
2.5
in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
2.3
in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.0
in %bids___i_period_sub_35% gün içinde122%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde235%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
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 resul Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
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 Cryst Daha Fazla

in %bids___i_period_sub_35% gün içinde125%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
haithambayoud

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

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
ihshsl

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.4
analistaplsql

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

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0