We are near the end of the actual writing of the 23c New Features book. My friend, Tom Kyte, has offered to add some running commentary which we are calling "Tom says". In the process, Tom is also offering up some technical comments. I had finished up Chapter 6, which includes coverage on a new feature called Pattern Matching. To be honest and embarrassed a bit, Tom replied that he didn't like my example. In fact, he kind of hated it. There were many reasons why, and I agreed with 90% of them.
So, after feeling really depressed I thought... Well, back to the drawing board with my example. Then it struck me that this is actually an opportunity.
So, I'm giving YOU an opportunity to be published. In the comments to this post (and please copy me in email at firstname.lastname@example.org), respond with the following by midnight 7/15:
- Write a query using the new Oracle Database 12c Pattern Matching feature.
- Include sample output demonstrating the query.
- Provide all DDL required to re-create the query including the creation of the table (and any other objects), and creation of all data in that table.
- The query should be SIMPLE for a first time user to follow, but not so simple that it can be replicated with a SQL statement easily not using the pattern matching feature.
One awesome entry will be selected for publication (assuming a get an awesome entry - I do not guarantee that any entry will be selected).
I'll contact you if you are selected and then we can work out the legal details. Note that if you are selected you will not be compensated for your entry or any additional follow-up work that you might be asked to do. You will have to warrant that it's your own and give Oracle Press rights to publish it under their copyright. Your name will appear in the acknowledgements of Oracle Database 12c New Features for all your jealous co-workers to oooohhh and aaawwwwhhhh at!
So, get cracking and learn about and use Oracle Database 12c Pattern Matching!
P.S. -- Here is a starting place....