Oracle VM Consulting
view counter

PL/SQL Feed

Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

PostgreSQL Types

PostgreSQL like Oracle supports record data types but unlike Oracle, PostgreSQL doesn’t support collections of record data types. Here’s an example of how to define a PostgreSQL composite data type, and how to use it as a column’s data type.

PostgreSQL Auto Increment

PostgreSQL’s approach to automatic numbering, is simpler than Oracle, MySQL, and Microsoft SQL Server. For example, you have a two-step process with Oracle, MySQL, and Microsoft SQL Server. First, you create an Oracle table with the GENERATED AS IDENTITY clause, a MySQL table with the AUTO_INCREMENT clause, and a Microsoft SQL Server table with the IDENTITY(1,1) clause. Then, you need to write an INSERT statement like:

Results of 2014 Annual Logic Championship

You will find below the rankings for the 2014 Logic Championship; the number next to the player's name is the number of times that player has participated in a championship.

Congratulations first and foremost to our top-ranked players:

1st Place: Mehrab of United Kingdom - 100% correct!

1 Uncool Thing about the COMPARE_SYNC Package

It only works in version 12 :( That’s right, I didn’t test in previous versions and there was a bug. Please refer to the COMPARE_SYNC post for the new, improved version. Here is what I changed: The name is now COMPARE_SYNC. I don’t know what got into me to put those four meaningless letters in front. The […]

APEX: Active Tabs Based on Page Groups

Recently someone asked me: "How did you do that? When I include an APEX page in a Page Group, the correct tab is automatically highlighted"
When I setup an application, I usually use Dimitri Gielis' method, so instead of using "real tabs", I use a List and display that list as Tabs.

Comparing NULLable Values

If a column or expression may be NULL, it is a pain to compare it to something else. Why? Because comparisons involving a NULL do not result in TRUE or FALSE: they result in NULL. I use the DECODE function to work around this problem: here's why - and how.

OTN Yathra 2015 just got over!!

Quite well said – Investment in knowledge is the gives you the best returns. It was a great fun last week to be the speaker at OTN Yathra 2015, organized by All India Oracle Users Group (AIOUG). The OTN tour covered seven cities and I was the part of it at three cities i.e. Hyderabad, Bangalore … Continue reading →

Database design resources: My reading list

Following the database design championship playoff over on the PL/SQL Challenge, one player asked:
“Could you please advise me some resources (boooks, courses) so that I can improve?”
Of course I can! This is what I love to hear – people looking for resources they can use to increase their skills. This is information I’m sure others will benefit from, so here goes:

PL/SQL Championship for 26 February Postponed

We will NOT hold the championship today.

Even if the website becomes available within next two hours, I do not want to take a chance at starting the competition and then having problems before it is done.

We will reschedule for a day and time in March.

Participants will receive an email for a new date and time soon.

But based on requests from the last one, I will put this out idea out now:

What do you think of holding the championship on Saturday?

Three Out of Four Isn't Too Bad

We held two annual championships last week (SQL and Database Design).

We held a third this week on Logic.

They all went pretty smoothly.

In 2.5 hours it is time for the grand finale: the PL/SQL Championship.

And the PL/SQL Challenge website just went down. Possibly another DDOS attack.

I suppose I should feel proud that our website is so high profile, so mission critical, that someone thinks it is worth their time to attack it.

view counter