Working with people in different timezones can be a challenge. Often we are requested to do some work for an internal organization of a external client at a time during which we are not working. The requested time may fall into someone's timezone who would be working during the time when the work has to…

Working with people in different timezones can be a challenge. Often we are requested to do some work for an internal organization of a external client at a time during which we are not working. The requested time may fall into someone's timezone who would be working during the time when the work has to…

Working with people in different timezones can be a challenge. Often we are requested to do some work for an internal organization of a external client at a time during which we are not working. The requested time may fall into someone's timezone who would be working during the time when the work has to…

Working with people in different timezones can be a challenge. Often we are requested to do some work for an internal organization of a external client at a time during which we are not working. The requested time may fall into someone's timezone who would be working during the time when the work has to…

Working with people in different timezones can be a challenge. Often we are requested to do some work for an internal organization of a external client at a time during which we are not working. The requested time may fall into someone's timezone who would be working during the time when the work has to…

Hasty and incomplete preparation are two of many pitfalls all too common when performing maintenance activities. The approach one uses to prepare and document work performned has a direct and dramatic influence on the likelihood the work will be done: at the right time in the right place in the correct order in a fashion…

Hasty and incomplete preparation are two of many pitfalls all too common when performing maintenance activities. The approach one uses to prepare and document work performned has a direct and dramatic influence on the likelihood the work will be done: at the right time in the right place in the correct order in a fashion…

Hasty and incomplete preparation are two of many pitfalls all too common when performing maintenance activities. The approach one uses to prepare and document work performned has a direct and dramatic influence on the likelihood the work will be done: at the right time in the right place in the correct order in a fashion…

Hasty and incomplete preparation are two of many pitfalls all too common when performing maintenance activities. The approach one uses to prepare and document work performned has a direct and dramatic influence on the likelihood the work will be done: at the right time in the right place in the correct order in a fashion…

A summary and illustration of set-based SQL syntax as well as manipulation and use of SQL collections.  Examples will build from correlations to mathematics set theory through the powermultiset operators.  Collections will be created using native sql functions as well as pl/sql table functions.  The presentation ends with illustrations of recursive queries to solve set…