Oracle VM Consulting
view counter

PL/SQL Feed

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

Implicit Commit Functions?

Somebody asked about the possibility of putting DML statements inside MySQL stored functions. DML statements like the INSERT, UPDATE, and DELETE. When I said, “Yes, you can put DML statements inside functions.” They showed me the error they encountered, which is only raised at compilation when you put an explicit COMMIT statement or a Data Definition Language (DDL) statement (CREATE, ALTER, DROP, or RENAME) inside a MySQL function. The actual error message displayed is:

500,000 Answers on the PL/SQL Challenge!

Over the weekend of 2 June, we reached a major milestone on the PL/SQL Challenge: the 500,000th answer to a quiz was submitted!

Altogether, a total of 9,503 players from 120 countries have submitted (at the time of writing this post) 501,623 answers to quizzes. They used a total of 5770 days' time to decide on their choices and submit the answers.

Over 500,000 Answers Submitted on the PL/SQL Challenge!

Over the weekend of 2 June, we reached a major milestone on the PL/SQL Challenge: the 500,000th answer to a quiz was submitted!

Altogether, a total of 9,503 players from 120 countries have submitted (at the time of writing this post) 501,623 answers to quizzes. They used a total of 5770 days' time to decide on their choices and submit the answers.

Of course, the vast majority of those answers were submitted by a much smaller "core group" of Oracle technologists who play the daily PL/SQL quiz each day, or close to it.

Win a Free Copy of Packt’s Oracle book

Gladly I would like to announce that Packt publishing has arranged a GiveAway contest for “Oracle Advanced PL/SQL Developer Professional Guide” especially and exclusively for the readers. It’s easy to participate and walk away with your copy.

PL/SQL Popularity

TIOBE tracks the "popularity" of programming languages.

WebSockets Introduction

The topic of WebSockets came up today, and it seems a good idea to qualify WebSockets in the blog beyond simply pointing folks to Kaazing. HTML5’s WebSockets are a great fix for the half-duplex world of AJAX. They certainly have the potential to be more scalable than current Comet solutions, and present a real-time communication alternative.

Q1 2012 Championship Playoff Results

You will find below the rankings for the Q1 2012 playoff; the number next to the
player's name is the number of times that player has participated in a playoff.
Congratulations first and foremost to our top-ranked players:

1st Place: Chad Lee, United States, wins an
Amazon.com US$250 Gift Card.
2nd Place: Niels Hecker, Germany, wins an Amazon.com
US$175 Gift Card.
3rd Place: Ivan Blanarik, Slovakia, wins an
Amazon.com US$100 Gift Card.
view counter