Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why Use PL/SQL?

Steven Feuerstein-OracleDec 17 2015 — edited Dec 19 2015

"Large software systems must be built from modules. A module hides its implementation behind an interface that exposes its functionality. This is computer science’s most famous principle. For applications that use an Oracle Database, the database is the persistence module. The tables and the SQL statements that manipulate them are the implementation details. The interface is expressed with PL/SQL. Developers and users of applications built this way are happy with their correctness, maintainability, security, and performance. But when developers follow the NoPlsql paradigm, their applications have problems in each of these areas and users suffer. Why Use PL/SQL? provides PL/SQL devotees with unassailable arguments to defend their beliefs against attacks from skeptics. Skeptics who attend will see the light."


So says @"Bryn.Llewellyn-Oracle", Distinguished Product Manager for PL/SQL and edition-based redefinition.


Check out his Why Use PL/SQL? whitepaper!


Please post all comments about this whitepaper on the blog.

Comments
Post Details
Added on Dec 17 2015
7 comments
1,524 views