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.

Oracle on Amazon EC2 Cloud – APEX, Apps, Middleware, and DB Virtualized Hosting

AshokIndustry Trends, News and Updates, Offerings1 Comment

The economy is evolving, technology is getting better, and overall, the game is changing with cloud computing. M&S is now resellers for the Amazon EC2 Cloud, providing customers with access and expertise to make their enterprises run on “the cloud”. To host an enterprise environment, let alone Oracle, simply does not appear cost effective in the long run. In fact, I am open to healthy discussion contending that statement.

Move Oracle Linux VM to New Machine – Static IP

AshokTechnical TipsLeave a Comment

I just copied an Oracle Enterprise Linux VM from one Windows machine to another and the IP address for the guest Linux machine changed. I had a feeling that this might happen, but wasn’t quite sure why it did nor how to get it back to the old IP address. As we all know, an IP address changing in an Oracle environment is best avoided.