Search

OakieTags

Who's online

There are currently 0 users and 23 guests online.

Recent comments

March 2016

Best Practices with Enterprise Manager 13c

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!

ANSI Join Syntax in SQL Server

Writing your database queries using explicit join syntax helps toward
clarity and readability while reducing the opportunity for error and wrong
results.



Read the full post at www.gennick.com/database.

ANSI Join Syntax in SQL Server

Another in a series of posts in response to Tim Ford's #EntryLevel Challenge.


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. 

Clear Intentions

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 – the personal touch

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.

New Oracle Cloud Offering – Indexing as a Service (IDXaaS) (I Pity The Fool)

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 […]

Dealing with URL’s

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

Opatch quick tip

I was patching my 12.1.0.2 home installation to the latest patchset today, and got the following error:

3 Days of Oracle Security Training In York, UK

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

The company that is most responsible for NoSQL is not Amazon but Oracle Corporation.(read more)

The First and Last Word on NoSQL

Amazon had the first word on NoSQL but the creator of relational theory, Dr. E. F. Codd, gets the last word.(read more)