Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

SQL execution in Java

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Can someone help me executing the following SQL in java using JDBC?



The SQL is doing the following steps:

Retrieves all emp_ids having more than 1 '01-jan-3000' end dates;
--Uses oracle window function to retrieve start date for next row in partition for particular emp id subtracts 1 day from next start date to correct end date
--updates ent_emp_policy using Merge to correct ENT EMPPOL_END_DATE for that particular ENTEMPPOL_ID
 
lowercase baba
Posts: 13089
67
Chrome Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
I don't think what the query does matters...

Do you have any code at all? I guess what I'm asking is what part exactly do you need help with? If you show us what you have so far, and what errors (if any) you are getting, you're more likely to get help.
 
Sheriff
Posts: 11604
178
Hibernate jQuery Eclipse IDE Spring MySQL Database AngularJS Tomcat Server Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
This question looks very similar to the topic you have started here.

Because both topics are about executing SQL statements using JDBC (and it makes no difference which SQL statements you try to execute), I close this topic and the discussion/help/guidance will be continued in the aforementioned topic.

PS. Always use code tags when posting code to the forums. Unformatted or unindented code is extremely hard to read and many people that might be able to help you will just move along to posts that are easier to read. Please click this link ⇒ UseCodeTags ⇐ for more information. Properly indented and formatted code greatly increases the probability that your question will get quicker, better answers. I've gone ahead and added the code tags for you. See how much easier the code is to read? If you want to see a few usage examples (and which options you can use), have a look at the Using Code Tags section of the Ranch Guide.
 
Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic