view counter

PL/SQL Feed

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

It's Yes Time!

Finally after many years of being complicit in the poisoning of our own bodies, many people are coming to realize that lots of the food products (as opposed to food) that we buy in supermarkets are bad for us, make us sick. Thanks, Michael Pollan and others for your impact!


This shift in public opinion is revealed in changes in advertising by the companies who sell industrialized, factory-produced edibles. 

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.

view counter