Oracle Virtualization and Cloud Consulting
view counter

PL/SQL Feed

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

Tweaking the Weekly Quizzes at the PL/SQL Challenge

We've decided a couple of things:

  1. Enough with the really dull names as in "Weekly SQL Quiz".
  2. It's time to start up Deja Vu quizzes for SQL, Database Design, and Logic.
So starting on 4 April 2015 (just shy of the fifth anniversary of the PL/SQL Challenge)....
SQL Quizzes
We will rename and continue the weekly SQL quiz as Select from SQL.

And we will add a Deja Vu SQL quiz.

Lowercase Table Names

A student posed the question about why table names are case sensitive. That’s because case insensitive table names are the default installation, as qualified in the MySQL documentation. You can verify that with the following query:

Join Tables on Date Ranges

A recent question on the OTN SQL forum asked how best to join two tables related by ID and date range, in order to insert one row per date into a data warehouse. One solution was to expand the data from each table, creating one row per date, then join on date. I think it's more efficient to join on date range, then expand.

Results of 2014 PL/SQL Championship

You will find below the rankings for the 2014 PL/SQL Championship; the number next to the player's name is the number of times that player has participated in a championship (you will see "1" for all players, since this was the first annual PL/SQL championship).

Congratulations first and foremost to our top-ranked players:

1st Place: mentzel.iudith of Israel

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.

view counter