MyOraclePortal (MOP Blog)

Transform rows to delimited string value using SQL

Barry Chase — Tue, 06 Mar 2012 22:42:00 +0000

Now to go the other way... Prior to Oracle 11gR2, this required a number of creative solutions that can be found on AskTom.oracle.com. Now you can use a built-in listagg aggreation utility. e.g. listagg (ename, ',') where you can pass in…

Original post blogged on b2evolution.

Transform delimited string to rows using SQL

Barry Chase — Tue, 06 Mar 2012 22:40:00 +0000

This is a nifty little SQL for taking a field with multiple words, and parsing each word into a separate rows based upon spaces. The text in bold is the core SQL of data you wish to work with thus you can add conditions there to filter the data desired.

Original post blogged on b2evolution.

Who Called Me - Debug Tool - Seeded Feature

Barry Chase — Wed, 29 Feb 2012 14:21:00 +0000

When working with complex operations and logic, it can be quite difficult understand the flow of data when problems come up. I have built WHO CALLED ME type logic components and they have been very helpful as debugging tools. I simply leverage them with…

Original post blogged on b2evolution.

Oracle Support Mobile Edition Now Available

Barry Chase — Sat, 31 Dec 2011 20:16:00 +0000

Excerpt from Oracle Announcement : This first release of My Oracle Support Mobile focuses on the most frequent customer activities, namely viewing and updating Service Requests (SRs). We plan to release additional capabilities in the near future. Pleas…

Original post blogged on b2evolution.

Why Lines-of-Code is a Silly Metric

Barry Chase — Fri, 23 Dec 2011 18:21:00 +0000

Using metrics to measure progress is not inherently bad, but you have to make sure that you measure meaningful things. Measuring business value delivered over time is a good idea (if you can find a way to do it). Measuring lines of code is not. Why? Because on its own, a line of code is not particularly meaningful. If programmer A takes 100 lines of code to achieve the same functionality that takes programmer B 10 lines, is A ten times as productive as B? Quite the opposite.

Original post blogged on b2evolution.

PLSQL FTP Update

Barry Chase — Sun, 04 Dec 2011 17:07:00 +0000

Though not published online yet, I have made the promised updates to the FTP code that will introduce the following : MPUT MGET LOB enhancement to expedite data transfers Enhanced Debugging XML Formatting of NLST Obscuration of Use…

Original post blogged on b2evolution.

From-Spoofing

Barry Chase — Sat, 19 Nov 2011 23:56:00 +0000

If you are getting spam from this domain, let me apologize in advance. Unfortunately, From-Spoofing is one of the most common spam methods in use for which there is no defense. Let me reassure you, that I have and never will participate in spam type acti…

Original post blogged on b2evolution.

Rams' ten principles of "good design"

Barry Chase — Fri, 04 Nov 2011 15:13:54 +0000

Dieter Rams (born May 20, 1932 in Wiesbaden, Hesse) is a German industrial designer closely associated with the consumer products company Braun and the Functionalist school of industrial design.Is as little design as possible - Less, but better – because it concentrates on the essential aspects, and the products are not burdened with non-essentials. Back to purity, back to simplicity.

Original post blogged on b2evolution.