Oracle VM Site Review - Oracle VM Health Check
view counter

PL/SQL Feed

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

Value or Reference?

In class today, we reviewed pass-by-value (IN-only mode) parameters and pass-by-reference (INOUT and OUT mode) parameters for stored procedures.

A long long proof

Decomposition of a relation into join of projections serves as motivation for database normalization theory. In relational lattice terms relation x projected into sets of attributes (that is empty relations) s and t:

x = (x v s) ^ (x v t)

Lets investigate dual perspective and switch the roles of join and inner union:

x = (x ^ s) v (x ^ t)

PL/SQL # Tip: Locally declared subprograms in PL/SQL

Hi all, From long time, I am planning to start a blog section on PL/SQL programming tips. I have observed that as we grow more in technology, we skip some of the key features of language. When discovered later, the same tip appears to be an important bottleneck in programming.

Update on Q1 2012 Playoff

As some of you may recall, we started a new qualification procedure for this playoff, in which a selected subset of the top-25 ranked players are asked to take three qualifier quizzes to verify their outstanding performance in the previous quarter.

For the Q1 2012 playoff, we asked six players to take the qualifier quizzes.

Raw+Material=Art

My older son, Chris Silva, is an artist in many media: mural, painting, mosaic, music, video.

He is included in a massive and quite beautiful book titled "Raw+Material=Art".

If you're looking for a relatively inexpensive, high production value "coffee table book" that will delight your visitors and yourself, or if you are Chris Silva fan and must acquire everything that has anything of his in it, check it out!

Here are some links to information about the book:

WYSIWIG HTML Editing in Version 2.2 of PL/SQL Challenge

Many players have had the pleasure of submitting a quiz and then seeing it played by hundreds of developers aroudn the world. If you have not yet done so, I encourage you to give it a try.

Other players review quizzes to help us make sure they are free of errors and as interesting as can be.

All of these people provide content that usually benefits from HTML tags, especially showing code in a fixed font format.

A Discussion Forum on the PL/SQL Challenge?

A player submitted this request yesterday:

"Hello
Steven,

I just wonder that are you planning to open forum in pl/sql challenge?
Because I really would like to discuss and talk about quizzes. I think
the only shortage in this site is forum. There should be a forum for
users in order to discuss and talk about quizzes. Please do something for
this.

Thanks for your help."

view counter