>> Technical Resources>> Technical Search>> ODTUG Technical Journal>> Useful Links>> Blogs
SQL Content    
     
     
Sort by Column: Content Name Description Created On Authors
11g New Features for SQL and PL/SQL -
Uploaded on October 09, 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   649k 
Co-operating with the Database -
Uploaded on September 08, 2010
It is easy to write SQL that has to run inefficiently, and it is easy to write SQL that results in very unstable performance. In this presentation, Jonathan Lewis will take an example of each type of problem and explain why the developer sometimes has to do a little extra work, and introduce some extra complexity, in the front-end code to allow the database to respond efficiently and consistently.
Download   355k 
Data Modeling with Oracle SQL Developer Happy Days are Here Again! -
Uploaded on February 23, 2009
The eagerly anticipated Oracle SQL Developer Data Modeling Early Adopter Release is now available for download on OTN. It can connect to any Oracle database 9.2 or higher. This early adopter release is a standalone, file-based version, but the production release will have a repository. In the future, it may also be available as an extension to Oracle SQL Developer.
Download   309k 
Dynamic SQL in a Dynamic World - The Sequel -
Uploaded on October 09, 2008
This presentation will cover some of the less obvious issues that arise while using Dynamic SQL, including defining required privileges, preventing code injections, targeting performance tuning efforts, understanding resource utilization, handling object dependencies, etc. Examples will demonstrate when, why, and how to use Dynamic SQL in real-world situations in conjunction with other advanced features such as objects, object collections, ref cursors, and bulk operations.
Download   2080k 
How to Design Efficient SQL -
Uploaded on September 08, 2010
If you want to write an efficient query, you need to be familiar with the data, metadata, and the intent of the query. In this presentation, Jonathan Lewis will discuss the information you need to know (or collect), and then explain how knowing this information will allow you to construct a
Download   361k 
How to Design Efficient SQL -
Uploaded on September 08, 2010
If you want to write an efficient query, you need to be familiar with the data, metadata, and the intent of the query. In this presentation, Jonathan Lewis will discuss the information you need to know (or collect), and then explain how knowing this information will allow you to construct a
Download   95k 
How to Market MySQL to Your Manager -
Uploaded on September 20, 2010
Now part of the Oracle family of database server products, MySQL (www.oracle.com/mysql) is a widely used open source RDBMS. MySQL is very popular in the Web 2.0 and Internet startup space with many popular Web sites using MySQL for their primary data storage.
Download   2151k 
Introducing and Demonstrating Oracle Database 11gR2's Killer Feature -
Uploaded on September 08, 2010
Edition-based redefinition (EBR) in Oracle Database 11g Release 2 is spectacular, introducing a new dimension to the database which allows us to version objects within a schema. Through EBR, we achieve zero-downtime application upgrade and multiple application versions simultaneously against one schema. No more big-bang upgrade! This session introduces EBR, demonstrates the SQL, and shows the multi-version application. It dives into some complexities of data synchronization between editions and discusses best practices with EBR.
Download   1526k 
OMG! Identifying and Refactoring Common SQL Performance Anti-patterns -
Uploaded on September 08, 2010
You too can be a SQL performance hero without being a DBA. Many of today's SQL performance problems are due to poor design and poorly written SQL and are easily identifiable Anti-patterns. The presentation will discuss why developers produce poorly performing queries and applications, and offer quick fixes to many common SQL performance problems.
Download   1018k 
Oracle Extended SQL Trace Data for Developers -
Uploaded on September 09, 2010
Cary Millsap describes Oracle extended SQL trace data to developers so they can learn how to use this rich source of performance data to build faster, more scalable, more easily maintainable applications.
Download   6298k 
row(s) 1 - 10 of 15
Next
ODTUG.com is Powered by Oracle Application Express
SITE MAP  
 
NEWS & UPDATES
ODTUG COMMUNITY
UPCOMING EVENTS
TECHNICAL RESOURCES
ADVERTISE WITH US