Convert INT to BOOLEAN in a SQL SELECT for Multi-Tiered Sorting

john.kingTechnical Tips1 Comment

We have a family tree. Some people have children, while others do not. We want to sort results by alphabetically listing individuals with children in an initial group, and then those without children in a second group — also alphabetically. Let’s assume there is not an isParent column (nor the equivalent) on the table, but there is a way to determine how many children each individual has.

Oracle BPEL Sensors for Real Time Event Publishing from Business Processes – A Design Perspective

brian.sipseyIndustry Trends, Technical Tips1 Comment

This article is a look at Oracle’s BPEL Sensor approach to publishing real time data and events for in flight BPEL Processes.

Oracle BPEL has tried to fill a gap in the BPEL Spec using sensors. Specifically, sensors allow users to overlay listeners on BPEL tasks and process variables that will generate events out of a process that is being executed. This is definitely a step in the right direction, and does a good job of staying true to the BPEL specification. This document will define what sensors are, how they should be designed into BPEL Processes, and a future outlook of event models.