PL/SQL is more concise than Java.
You can call PL/SQL functions directly from SQL.
PL/SQL can run without human intervention.
Many cool features are only accessible via PL/SQL.




PL/SQL is more concise than Java
Using SQL statements within PL/SQL is free of programming "cruft" (programmer's slang for superfluous code). Without getting into the finer points about cursor-FOR loops, automatic declarations, statement parsing, etc. (described in later chapters), suffice it to say that PL/SQL can accomplish more using fewer lines of code than any other SQL-hosting programming language you care to use with Oracle. Well, at least when compared to Java.




You can call PL/SQL functions directly from SQL
Calling PL/SQL functions directly from SQL statements can often make your SQL shorter and more manageable. For example, you can define a PL/SQL function that computes some exotic mathematical relationship, and someone can later use that function in a SQL SELECT statement. In a library, maybe they have an algorithm for computing a book's popularity based on how frequently it gets checked out and how many times patrons request that it be held for them. This statistic, combined with the number of copies, helps the library determine whether to purchase any new copies of the book. We could create a PL/SQL function that computes a "scarcity" factor, and then write a relatively simple query to create a report:

SELECT isbn, title, scarcity(isbn)
FROM books
ORDER BY scarcity(isbn);





PL/SQL can run without human intervention
(and without any obvious divine intervention)
PL/SQL can be triggered automatically by other events in the database. For instance, if you want to get an email when a particular book gets returned to the library, PL/SQL can send it. Examples of trapping database events with table-level or database-level triggers written in PL/SQL .

Many cool Oracle features are only accessible via PL/SQL
Although Oracle rarely spells out this fact in black and white, there are extremely useful features such as Replication (for automatic copying of data between databases), the Spatial option (for the storage of maps and other location-dependent data), and Time Series (to help manipulate data with a strong time component, such as stock prices) that will require you to learn at least a little about PL/SQL. That's because these features currently have no alternative programming interface. (If truth be told, though, there are a few Oracle features, such as programming for the Internet File System or iFS, that are only available from Java.)

هذه المقارنة كمن يقارن صخرة بجبل ..
فيقول ان اهم مايميز الصخرة انها اخف وزنا .

لاتجوز المقارنه ياأخي

فانت لاتعتمد على معايير متشابهه أصلاً حتى تقوم بالمقارنه

هذه المقارنة كمن يقارن صخرة بجبل ..
فيقول ان اهم مايميز الصخرة انها اخف وزنا .

على الرغم من ذلك
فمعلومه مفيده