CODEWITHSUNDEEP
databasejdbcplsql
TJF
TJF

Reputation: 1101

advantages of JDBC over plsql?

I am revising for a databases exam. A previously asked question asks about the advantages of JDBC over plsql and viceversa?

I have found it easy to find advantages of plsql over Jdbc for example:

Better Performance- as with PL/SQL, an entire block of statements can be sent to Oracle at one time. This can drastically reduce network traffic between the database and an application.

Portability-Applications written in PL/SQL can run on any operating system and platform where the Oracle database runs

Productivity- implicit connection handling, intigrated termination test, cleaner parameter parsing.

Tight Security- PL/SQL stored procedures move application code from the client to the server, where you can protect it from tampering, hide the internal details, and restrict who has access.

what are advantages of JDBC over plsql?

Upvotes: 1

Views: 1508

Answers (2)

user800014
user800014

Reputation:

Database independence is good reason for using JDBC. Let's say that your web application needs to run for a customer that cannot pay for Oracle, how much work will you need to do to port to a open source database?

Upvotes: 3

memo
memo

Reputation: 441

JDBC is better if you have to do several calculations with your set of data, sometimes you can even do the joins in the client side releasing the server from doing such heavy work.

Upvotes: 1

Related Questions