How and When to Write SQL in PLSQL
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? The same or similar SQL statements repeated throughout the application, making it very hard to optimize and maintain the code.
This webinar starts by reviewing the role of SQL in PL/SQL applications, and the key challenges involved when writing SQL. We then step through the most important best practices for SQL construction, ranging from avoiding SQL repetition to full qualification of variable and column names.
After viewing this webinar, you will be well positioned to establish and follow a set of guidelines for SQL construction that will have a significant impact on application performance and maintainability.
https://asktom.oracle.com http://www.plsqlchallenge.com http://www.oracle-developer.net/ http://oracle-base.com/ http://www.oracle.com/webfolder/techn... http://goo.gl/FPG79Z http://stevenfeuersteinonplsql.blogsp... / sfonplsql
In questa pagina del sito puoi guardare il video online How and When to Write SQL in PLSQL della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Oracle Learning 09 luglio 2014, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 7,668 volte e gli è piaciuto 43 spettatori. Buona visione!
