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’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:
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!
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 […]
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.
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.
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 →
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:
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?
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.