We help IT Professionals succeed at work.
Get Started

Oracle store procedures for java programmers

royjayd asked
Last Modified: 2012-05-11
hi experts

I have an interview next week  on oracle store procedures and i would like to know what are the oracle 11i store procedure concepts used in realtime programming with a java front end. I am a java programmer so i dont have  to know hard core store procudures . I just need to know what Oracle Store procuedure Concepts a java programmer should know which will help me in the interview.
I have experience with SQL statements like SELECT/INSERT/UPDATE/DELETE.
But I have  little knowledge of store procedures , a little knowledge of using
explicit ref cursors.
Can someone outline the other important concepts i need to know?
Like Merge command?

thanks in advance,
Watch Question
Sr. Consultant
This problem has been solved!
Unlock 4 Answers and 5 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE