Recursive subquery factoring (AKA Recursive Common Table Expressions) has been available in Oracle since version 11g R2 was launched sometime around 2009. I always thought of it as a replacement for the connect by clause and just another way to write hierarchical queries, so I never really took the time (more...)
After my Kscope13 presentation, one of the attendees approached me and asked if I had used regular expressions to try to validate email addresses. He didn’t know about regular expressions before the presentation and he was writing a PL/SQL function (which was getting very complex…) to accomplish this particular task. (more...)
It has been a week since I returned from Kscope13 in New Orleans and just now I’ve found some time to write about it.
This was my first visit to this city and I really enjoyed running errands to see historic locations and looking for places to try the amazing (more...)
- 4½ days of great technical content for Oracle developers. Plenty of presentations and hands-on training on several areas such as APEX, BI, development tools, SQL, PL/SQL, (more...)
I was playing the pl/sql challenge the other day and the question was to identify valid implementations for a “reverse_string” function taking a varchar2 as the input and returning another varchar2 with the characters in inverted order.
One of the possible answers was this:
FUNCTION reverse_string (in_string VARCHAR2) RETURN VARCHAR2 (more...)
Well… I made it to Denver and this place is really coooold but it’s also really nice. I have this wonderful view from my hotel room.
This is just a quick post to say that I’ll be presenting on Wednesday 2/13. Here are the details of my session:
Introduction to Oracle Expressions in Oracle from 09:45 to 10:45 in room 4d
This will be the first time that I present at a conference, so as you can guess I’m a little bit anxious and nervous but I believe is normal.
I hope to see you at this great conference.
This is the second year in a row that I have the opportunity to attend the Oracle Open World Conference and looks like it’s going to be even better than last year’s.
I’ll be flying to San Francisco on Saturday morning and I’m planning to do some sightseeing at the Bay (a small cruise maybe) and hang out with some other conference attendees.
On Sunday I’ll be on all the ODTUG Database Development sessions.
From Monday to Thursday I’ll focus on sessions about database development, database performance, big data and some Exadata (looks like one of (more...)
It’s been several days since Kscope 12 ended and what a conference we had!
The User Group Oracle Development Tools (ODTUG) organized the best conference I have attended so far. Everything was impeccable, starting with the conference site (JW Marriott San Antonio), presenters, activities at the end of the day and of course the party at Knibbe Ranch with an incredible atmosphere, good music, drinks, games, Texas BBQ, and we even attended a rodeo!
Kscope was a great experience and I recommend it to all those who use Oracle tools for application development. Not only the (more...)