In our last episode, we left off with our “would-be” PL/SQL programmer trying to retrieve the first names of the Doe family members from table WORKER_T using a singleton SELECT. Little did our programmer know that Oracle has already solved this problem, and the magic required to pull off such a feat was already in his hands.
KeywordsContext Switch Code Table Manual Loop Worker Table Associative Array
Unable to display preview. Download preview PDF.