Since the introduction of Enterprise Manager 12c, folks have been asking for a list of best practices. I know a lot of you have been waiting for this post!
Anyone new to SQL Server will sooner or later, and probably sooner, encounter exhortations to write joins in "ANSI join syntax". While the term is misleading and in fact incorrect, the practice of using the so-called "ANSI join syntax" contributes toward queries that are easier to understand and maintain.
Following are two queries that produce the same result -- all possible combinations of product and subcategory names from the two tables listed in the FROM clause. (Such a result is termed a Cartesian product). Notice how I've written the joins in the respective FROM clauses.
AskTom has been answering questions from the user community for nearly 16 years.
But what if that service could have an even more personal touch ? We are pleased announce the largest advance in AskTom service since it started way back in 2000.
See all the details in the video below for the new service we are launching on April 1st.
This of course is an April Fools joke. Sorry !! A very exciting announcement !! I’ve recently been promoted within Oracle Corporation to lead their brand new Oracle Cloud offering “Indexing as a Service” (IDXaaS) team, based on my previous work and experience in the indexing space. Yes, I’m both thrilled and excited to be […]
If you are creating or handling URL’s, there is a nice little package routine that assists with handling all those pesky special characters. I’ve added a little wrapper just to make the parameter handling easier
I was patching my 184.108.40.206 home installation to the latest patchset today, and got the following error:
I have just updated the public Oracle Security training dates on our Oracle Security training page to remove the public trainings that have already taken place this year and to add a new training in York for 2016. After the....[Read More]
Posted by Pete On 31/03/16 At 01:53 PM
The company that is most responsible for NoSQL is not Amazon but Oracle Corporation.(read more)