>> Technical Resources>> Technical Search>> ODTUG Technical Journal>> Useful Links>> Blogs
PL/SQL Content    
     
     
Sort by Column: Content Name Description Created On Authors
11g New Features for SQL and PL/SQL -
Uploaded on July 30, 2008
Oracle 11g has more than 500 new features for DBAs and developers. The most significant SQL and PL/SQL new features and improvements will be covered. The focus is to help developers sort through all these new 11g SQL and PL/SQL features to find which ones are going to be the most helpful, and when and how to use them.
Download   29k 
Autonomous Transactions: Extending the Possibilities -
Uploaded on October 09, 2008
This presentation discusses when, why, and how to use autonomous transactions in conjunction with other features, such as object collections, dynamic SQL, INSTEAD OF triggers, etc. Additional focus will be placed on critical issues such as resolving self-mutating tables, preventing deadlocks, understanding read/write-consistency, and its corresponding side-effects. Real-life examples will be included to help attendees avoid hidden traps on the way to building systems better, faster, and cheaper.
Download   1214k 
Autonomous Transactions: Extending the Possibilities -
Uploaded on July 30, 2008
This presentation discusses when, why, and how to use autonomous transactions in conjunction with other features, such as object collections, dynamic SQL, INSTEAD OF triggers, etc. Additional focus will be placed on critical issues such as resolving self-mutating tables, preventing deadlocks, understanding read/write-consistency, and its corresponding side-effects. Real-life examples will be included to help attendees avoid hidden traps on the way to building systems better, faster, and cheaper.
Download   80k 
Book Review -
Uploaded on February 11, 2008
No Description
Download   648k 
Book Review: Advanced Oracle SQL Programming, Expert Guide to Writing Complex Queries -
Uploaded on February 23, 2009
Laurent Schneider, the author is an Oracle Ace and Oracle Certified Master. He has contributed to the Oracle Database SQL Language Reference, readers can follow his blog at http://laurentschneider.com. I like to read a lot of books on Oracle SQL including reference books and try to keep up with the latest features Oracle SQL offers, this book will remain in my library for quite some time.
Download   535k 
Book Review: Oracle PL/SQL Best Practices -
Uploaded on June 09, 2008
Author Steven Feuerstein is considered to be an authority on PL/SQL development. This book is not the first book a developer should read to learn PL/SQL. As the title notes, this is an excellent addition to any PL/SQL developers reference library and a must read for any team lead or manager of a development team predominantly using PL/SQL to develop applications. This book is not a quick read, as the concepts are very detailed and reader is encouraged to reference specific chapters as needed.
Download   733k 
Break Your Addiction to SQL -
Uploaded on November 16, 2007
Oracle PL/SQL makes writing SQL so darned easy in fact, it is way too easy to write SQL. As a result, PL/SQL developers take SQL totally for granted, and very few organizations have any sort of guidelines in place for when, where and how to write SQL. The result? Developers become addicted to writing SQL. Learn in this presentation what's so bad about writing SQL and how you should change your very naughty ways.
Download   2689k 
Building Robust Applications in a Database-Centric Way -
Uploaded on February 13, 2008
Can't keep up with all the new technology every year? Don't worry, there is one technology that has been around for 15 years and will most likely still be here for many years to come. And, you can use this *single* technology to build 80-90 percent of your application (all but the user interface). Needless to say this technology is database-stored PL/SQL. This session will detail a robust application architecture that I believe every shop that is committed to the Oracle dbms, should adopt.
Download   502k 
Coding with the Enemy: JDeveloper As a PL/SQL IDE -
Uploaded on February 12, 2008
JDeveloper as a PL/SQL IDE? This session demonstrates JDeveloper features for PL/SQL: context-sensitive editor, interfaces for object creation, code insight, shortcuts, web services generation, and local and remote debugging. Learn how to browse the database, build objects, code, debug, and test PL/SQL with this FREE IDE.
Download   932k 
Collect Yourself: Optimize PL/SQL Code with Collections -
Uploaded on November 16, 2007
Collections, array-like structures, are among the most important datatypes in PL/SQL. Yet relatively few developers know about and use collections regularly, and even fewer leverage them to the fullest possible extent. This session will quickly cover the basics of collections and then make you aware of some of the most interesting and powerful applications of collections.
Download   2058k 
row(s) 1 - 10 of 70
Next
ODTUG.com is Powered by Oracle Application Express
SITE MAP  
 
NEWS & UPDATES
ODTUG COMMUNITY
UPCOMING EVENTS
TECHNICAL RESOURCES
ADVERTISE WITH US