Oracle Virtualization and Cloud Consulting
view counter

PL/SQL Feed

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

It's Official - I am a Demigod

In its 11 June 2012 Database Application Developer Newsletter, Oracle writes  "The "PL/SQL 101" series, by PL/SQL demigod Steven Feuerstein, is the ultimate quick-start introduction to the language. Even if you are an experienced PL/SQL developer, you may find these articles a handy refresher on language fundamentals."

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.

view counter