Bookmark Topic Watch Topic
  • New Topic

SQL execution in Java

 
alfredo phoenix
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • 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
 
fred rosenberger
lowercase baba
Bartender
Posts: 12263
36
Chrome Java Linux
  • Mark post as helpful
  • send pies
  • 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.
 
Roel De Nijs
Sheriff
Posts: 10662
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • 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.
 
    Bookmark Topic Watch Topic
  • New Topic