Thoughts on the Oracle ACE Program

Four years ago during ODTUG KScope14, I was designated as an Oracle ACE in the area of Database Development. Vikki Lira, who ran the ACE program at the time, surprised me on stage during the General Session. I could not have been more shocked.  I think my actual response was "You gotta be _hitting me!". While I wish at the time I'd been a touch more eloquent, I'm still not over the shock and remain indebted to Tim Gorman (and anyone else who had a part in it).

Truth is, while I really appreciated the recognition, I had a serious case of survivors guilt. Why me when there are thousands of qualified Oracle professionals more deserving?? I mentioned it to Deborah Lilly and she said something that has stuck with me ever since. She said "It's not what you know, it's what you share"
In ten words or less she made me feel deserving. She made me feel like I belonged.

Did Groucho Get it Right??

We've all heard the famous quote from Groucho Marx.

"I refuse to join any club that would have me as a member"

                                                                             Groucho Marx

Funny enough, I found a notable Oracle personality who had this to say about the ACE program.

"By and large, they tend to be people with low self-esteem who can be easily flattered into promoting Oracle for free.  These ACE Directors are sometimes "legends in  own minds" and they are the perfect fodder for this unpaid army of Oracle evangelists."

Really?? I know everyone is entitled to their own opinion. Since I'm entitled to one too, let me say I couldn't disagree more with that assessment of Oracle ACEs. That doesn't describe me, I assure you. Trust the amount of Oracle gear, free meals, etc. is nowhere near worth us prostituting ourselves as was contended. We do it because we've bought into the sense of community. We view it as a way to "pay it forward".

Yea, we all have different personalities. We all have different Oracle skillsets. Some of us are more introverted...more extroverted. But the resulting nerd gumbo is really something to behold. I've found the ACE community to be welcoming and I look forward to the social times Jennifer and Lori carve out for us at the various conferences.

What's It All Mean Really?

I guess it means different things to different people. Anyone who tells you they don't care about recognition isn't, in my opinion, being entirely honest. Recognition taps into basic human emotions. Some crave it more than others, but we all need it at some level.

Receiving Your Oracle ACE Should Be The Beginning

It's always been my understanding that the "Oracle ACE is recognition for past deeds and accomplishments, while Oracle ACE Director is recognition for what you will do in the future." I want to challenge that. Receiving your Oracle ACE should in no way be viewed as reaching any mountaintop. Even if you don't strive for Oracle ACE Director, you should continue to do those things that brought you the ACE in the first place.

I will close by encouraging those who aspire to be part of the ACE program to not be dissuaded. Always remember... it's not what you know, it's what you share.

...our journey continues

Thanks, LISTAGG. I owe ya one.

My son is in Boy Scouts and their fundraising campaign involves the placement of U.S. Flags on certain holidays. In it's infancy it was all handled via spreadsheets. You can do that when you're only talking a limited number of flags.

I, of course, wrote an APEX app for it.

It's what you do when you do what we do.

Since this wasn't a paid gig, I re-purposed the "Sample Database App". Everything was coming along. The desktop functionality was in place and looking grand. The mobile functionality one needed in the field was taking shape. I got to a mobile list view that needed to list the address and under it the details of the individual flags on that property....could be one...could be many. Not difficult but I wanted an elegant solution that wouldn't add rows to my list view.

Let's look briefly at the source code...

   select f.flag_id,
          c.address,
          f.flag_nbr,
          f.flag_desc,
          f.active
     from customers c,
          flags f
    where c.customer_id = f.customer_id

Nothing to get excited about here.

Looking at the Advanced Formatting options for the List View...

 
Hmm. This could potentially add blank lines. What I really needed to do is aggregate the list of flags for that property. What I really need is something like this...

Enter LISTAGG. I assume we've all used listagg to do this very thing but I didn't want the result to simply be a concatenated string of "Flag1, Flag2, Flag3, FlagN"...or did I?  A few well placed P's here and there and I got exactly what I wanted.

and here's the big reveal..."Move that Bus!"






















Exactly what I needed. LISTAGG provided me a way, for display purposes, to effectively pivot the data. The takeaway here is don't rule out things like LISTAGG because at first glance they don't appear to deliver what you need. In this case the concatenated string I received just needed a little TLC.


...our journey continues