The twelve days of … AskTom

Posted by

On the 1st day of AskTom, a poster sent to me

A question about 12c

 

On the 2nd day of AskTom, a poster sent to me

two SQL queries,

in a question about 12c

 

On the 3rd day of AskTom, a poster sent to me

three table joins,

two SQL queries,

in a question about 12c

 

On the 4th day of AskTom, a poster sent to me

four nested queries,

three table joins,

two SQL queries,

in a question about 12c

 

On the 5th day of AskTom, a poster sent to me

five pattern matches,

four nested queries,

three table joins,

two SQL queries,

in a question about 12c

 

On the 6th day of AskTom, a poster sent to me

six analytic functions,

five pattern matches,

four nested queries,

three table joins,

two SQL queries,

in a question about 12c

 

On the 7th day of AskTom, a poster sent to me

seven regular expressions,

six analytic functions,

five pattern matches,

four nested queries,

three table joins,

two SQL queries,

in a question about 12c

 

On the 8th day of AskTom, a poster sent to me

eight model clauses,

seven regular expressions,

six analytic functions,

five pattern matches,

four nested queries,

three table joins,

two SQL queries,

in a question about 12c

 

On the 9th day of AskTom, a poster sent to me

nine object types,

eight model clauses,

seven regular expressions,

six analytic functions,

five pattern matches,

four nested queries,

three table joins,

two SQL queries,

in a question about 12c

 

On the 10th day of AskTom, a poster sent to me

ten cubes and rollups,

nine object types,

eight model clauses,

seven regular expressions,

six analytic functions,

five pattern matches,

four nested queries,

three table joins,

two SQL queries,

in a question about 12c

 

On the 11th day of AskTom, a poster sent to me

eleven policy functions,

ten cubes and rollups,

nine object types,

eight model clauses,

seven regular expressions,

six analytic functions,

five pattern matches,

four nested queries,

three table joins,

two SQL queries,

in a question about 12c

 

On the 12th day of AskTom, a poster sent to me

twelve optimizer hints,

eleven policy functions,

ten cubes and rollups,

nine object types,

eight model clauses,

seven regular expressions,

six analytic functions,

five pattern matches,

four nested queries,

three table joins,

two SQL queries,

in a question about 12c

 

and I said….

 

THANK YOU FOR PROVIDING A TEST CASE !!!!!

 

Thanks to all those people who have been using AskTom since Chris and I took the reins in September.  We value your questions – we hope you are getting value out of our answers.  Just dont forget to provide us with test cases Smile

3 comments

  1. You really took upon yourselves a tremendous challenge …
    AskTom is the most demanding task for any Oracle professional.
    I can only wish you full success and I am sure you will enjoy the deep appreciation of the entire Oracle community :):)
    I can only be sorry that I never got a similar opportunity, but will always be happy to follow-up
    after any news :):)

Got some thoughts? Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.