PL/SQL

trupti nigam

Ranch Hand

Posts: 647

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

When should one decide to use PL/SQL instead of regular sql queries?

Thanks,
Trupti

Paul Sturrock

Bartender

Posts: 10336

I like...

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

When you need behaviour not supplied by standard SQL and when you have funtionality that sits better in the database rather than in an external application.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch

Robert Hayes

Ranch Hand

Posts: 116

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Let me add that one of our Oracle PL/SQL gurus at work recently switched to Java for one of his projects and was very pleased with his experience.

Oracle offers Java sprocs; you may want to look into it.

Consider Paul's rocket mass heater.