FreeQL – Free Oracle SQL Select Statements

AshokOfferingsLeave a Comment

M&S Consulting has begun a revolutionary service where we will write Oracle SQL statements for FREE. We have named this service FreeQLTM.

ms_freeql_logov1

Who can use FreeQL?

Anybody can request an Oracle SQL statement to be written, as complex as you desire. You must provide a valid, non-free email address that we will use to communicate with you. That means that we will not entertain requests from gmail, hotmail, yahoo, etc.

What’s the catch?

With years in the business writing high performing, very practical SQL statements for Oracle customers (many in the business intelligence space), we want to share our knowledge and get the word out about our skills, ability, and friendly business style.

You are welcome to sign up for our newsletter or make a small payment if you desire, though that is not a requirement.

I’m in. Now what?

Simply populate the FreeQL form and we will respond to you with SQL. Everyone wants something without spending money…and we’re here to give it to you!

Oracle BPA Suite and SOA Suite – Combined

AshokIndustry Trends, OfferingsLeave a Comment

Oracle has made some great strides with their BPM and SOA offerings. For M&S, combining process and technology has become even more exciting with Oracle’s tools. For the first time, Oracle has made it possible for our consultants to more easily bring together best of breed solutions (IDS Scheer’s ARIS and Oracle SOA) and leading industry standards (BPMN, BPEL, and BPEL4People) to our implementations, which typically involve some level of process management/improvement and technology automation (workflow and reporting). Following is a quick image of how each person in an organization fits into our approach when combining process with technology using … Read More

Conditionally Purge BPEL Instances on 10.1.3.x

AshokOfferings, Technical Tips1 Comment

Marc Kelderman wrote a helpful article on this topic: http://orasoa.blogspot.com/2007/03/delete-bpel-instances.html One of the users there notes: Note there is a patch to 10.1.3.3 to purge old data (6372741). Its a fairly dumb one that deletes everything older than a given date. Trying to do something more elaborate we have noticed that if you use the script in this article as a basis then rows in xml_document table are not removed. We have written code to conditionally purge BPEL instances in a sophisticated manner, taking into account custom logic, scheduling, and performance for multiple customers in SOA/BPEL versions 10.1.2 and 10.1.3.x. … Read More