Working with Oracle Documentation

When I open Oracle documentation to look for something, people usually raise their eyebrows (almost as they do when I open sqlplus). Most of them simply say: “What do you need the documentation for? Just open google and search”. Even though googling stuff usually works, I actually like the documentation (in some aspects at least). … Continue reading Working with Oracle Documentation

Israelis in the Wide World

I ran into this post on Linkedin talking about what non-Israeli people should expect when working with Israelis (and especially if they visit Israel for business). It’s a very nice read and it’s not long. After reading it (and laughing to myself, as it’s quite accurate), I decided to write this post. Most of the … Continue reading Israelis in the Wide World

Using Different Languages in Oracle – Part 2

In the previous part (you can find it here) I discussed the character sets Oracle supports and the length limits. In this part I’ll show how it is actually stored and discuss some more topics that are relevant to using different languages with Oracle. Seeing the Data In order to see how Oracle saves the data, … Continue reading Using Different Languages in Oracle – Part 2

Oracle 12.2 is Released!

Remember my post about Oracle 12.2 release date? I’ve heard rumors that Oracle changed the date to March 1st, and it was right! Oracle 12.2 is available for download for Linux x86-64, and Solaris (both SPARC and x86-64). I don’t know the release dates for other platforms. This is the download page: I’m downloading … Continue reading Oracle 12.2 is Released!

Even More 12.2 Features

A few days ago I was browsing the documentation and suddenly realized that I haven’t gone over the 12.2 books. One of the things I like to do is reading the “New Features” guide, so I did. After writing about the major features, here are some smaller ones, but still important enough to know. Transparent … Continue reading Even More 12.2 Features

Oracle 12.2 Release Date

Oracle 12.2 is going to be a very interesting one with lots of great features. I published a few blog posts about some of the features, you can read about it here: Oracle 12.2 Cool New Features More Cool 12.2 Features Oracle 12.2 Sharding Option I recently saw a tweet from Tim Hall mentioning a … Continue reading Oracle 12.2 Release Date

Did You Know #18 – Order By Position

When writing a query with order by, we can use the column position instead of its name. This order by”trick” is easy to use, but should be handled carefully as it affects the order of rows if the column list changes. For example, these two are equal: select col1,col2,col3 from table1 order by col1,col2; select … Continue reading Did You Know #18 – Order By Position

Scanning an Index

The internet is full of information about indexes, and for a reason. Indexes in a database is probably the most important performance related topic. There are so many cases, properties, and different ways to use indexes that there is simply a lot to write about. In this post I’d like to talk about a specific … Continue reading Scanning an Index

Did You Know #17 – DBMS_STATS

Many people are using DBMS_STATS to gather optimizer statistics. This package has many different options, and I wanted to tell you about one option for disabling automatic statistics gathering. When we need to disable the automatic statistics gathering we usually do one of the following: Disable the job itself (using DBMS_AUTO_TASK_ADMIN). This completely disables the job so no … Continue reading Did You Know #17 – DBMS_STATS

Did You Know #16 – Package Permissions

When user A creates a procedure and grants execute permissions to user B, user B can execute the procedure (obviously), but he can also see the code (in ALL_SOURCE view). With packages this scenario is a little bit different. When user A creates a package and grants execute permission to user B, user B will … Continue reading Did You Know #16 – Package Permissions