Steven Feuerstein published a series of "PL/SQL 101" articles in Oracle Magazine to help developers new to PL/SQL quickly come up to speed on the language. Read the Freedom, Order, and PL/SQL Optimization whitepaper on PL/SQL's powerful optimizer, the go-to document for any questions regarding the behavior of PL/SQL programs compiled at optimize levels higher than 1. You can choose to play competitively, ranking yourself against hundreds of other developers from around the world, or play simply to depend your experience. Join the PL/SQL Challenge community and try out these PL/SQL quizzes, learn as you go. Redefinition, explains the thick database approach in detail This approach is generallyĬalled the thick database paradigm, because PL/SQL subprograms inside the database issue the SQL statements fromĬode that implements the surrounding business logic and because the data can be changed and viewed only through a PL/SQL interface.īryn Llewellyn, Distinguished Product Manager for PL/SQL and Edition-based Implementation details - the tables and the SQL statements that operate on these. The time-honored way to ensure this is to expose the database only via an interface that hides the An application that uses Oracle Database is worthless unless only correct and complete data is persisted.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |