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…

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…

Original Broadcast: Thursday, January 29, 2015 Want to learn how to make Oracle and PeopleSoft application changes fast, reliably and compliant? Due to time constraints and overloaded schedules, Oracle Application business analysts and super users sometimes take short-cuts and make unauthorized changes directly in their production environment.  Why?  The changes are usually in response to…

Original Broadcast: Thursday, January 29, 2015 Want to learn how to make Oracle and PeopleSoft application changes fast, reliably and compliant? Due to time constraints and overloaded schedules, Oracle Application business analysts and super users sometimes take short-cuts and make unauthorized changes directly in their production environment.  Why?  The changes are usually in response to…

Bored of slides about Multitenant? Join this session and see with your eyes how Pluggable Databases work in a Maximum Availability Architecture. Start your journey through a structured sequence of slides and demos and learn how to deal with PDB creation, services and failovers in one of the most complex and beautiful architectures you can…

Bored of slides about Multitenant? Join this session and see with your eyes how Pluggable Databases work in a Maximum Availability Architecture. Start your journey through a structured sequence of slides and demos and learn how to deal with PDB creation, services and failovers in one of the most complex and beautiful architectures you can…

Bored of slides about Multitenant? Join this session and see with your eyes how Pluggable Databases work in a Maximum Availability Architecture. Start your journey through a structured sequence of slides and demos and learn how to deal with PDB creation, services and failovers in one of the most complex and beautiful architectures you can…

Bored of slides about Multitenant? Join this session and see with your eyes how Pluggable Databases work in a Maximum Availability Architecture. Start your journey through a structured sequence of slides and demos and learn how to deal with PDB creation, services and failovers in one of the most complex and beautiful architectures you can…

Bored of slides about Multitenant? Join this session and see with your eyes how Pluggable Databases work in a Maximum Availability Architecture. Start your journey through a structured sequence of slides and demos and learn how to deal with PDB creation, services and failovers in one of the most complex and beautiful architectures you can…

Bored of slides about Multitenant? Join this session and see with your eyes how Pluggable Databases work in a Maximum Availability Architecture. Start your journey through a structured sequence of slides and demos and learn how to deal with PDB creation, services and failovers in one of the most complex and beautiful architectures you can…