VF=>user  ID=>     Login Register
Feedback   FAQ   Blog
897,294 quizzes played * 1,078 active players * US$72,022 in prizes awarded

The PL/SQL Challenge offers an ever-growing library of information to help you become more expert in the Oracle technology stack. The Quizzes tab gives you access to all quizzes taken in the past. The Resources tab offers searchable access to many topics in Oracle documentation, to popular Ask Tom threads, and to fascinating blog posts from around the world. Utilities gives you quick access to SQL and PL/SQL utilities, i.e., reusable code. Visit Commentary to search across all quiz discussions.


All of the quizzes already taken by players are available on this page. You can search for a specific string in the topic for that question; filter for a particular type of quiz (you might, for example, want to check out the quizzes given in the last playoff); check out all the advanced quizzes, etc.

Filter Quizzes


View
Quiz
Played In
Feature / Summary / Author
Ended
OnDescending
Commentary
Pct Correct
Oracle Magazine QuizFeature and summary not shown till quiz has closed.

Author: Steven Feuerstein [10503-968803]

2015-02-28 SaturdayNo Comments
Last: No Comments
-
PL/SQL Explore

Packages: Instantiation and Initialization

The code in the initialization section of a package (after a "final" BEGIN that is not inside any subprogram of the package body) is executed once per session, to initialize the package. If the package is for any reason reset to uninitialized in that session (for example, with a call to DBMS_SESSION.RESET_PACKAGE) then the initialization code will be run again when that package is next referenced in the session.

Author: Steven Feuerstein [10613-1002519]
2015-02-27 FridayNo New Comments
Objections: SUBMITTED
Last: 2015-03-03 05:11:43
-
PL/SQL Deja Vu

Performance: Bulk Processing with FORALL and BULK COLLECT

Every loop that contains repeated execution of the same SQL statement (except for changes in bind variables) is a prime candidate for optimization with BULK COLLECT and/or FORALL.

Author: Steven Feuerstein [4502-1013119]
2015-02-27 FridayNo New Comments

Last: 2015-02-25 02:04:20
-
PL/SQL Challenge

Guidelines for IF and CASE Statements: Converting from DECODEs in PL/SQL

You do not need to use a SELECT statement to execute conditional logic in PL/SQL - and within SQL, you certainly no longer need to use DECODE.

Author: Steven Feuerstein [10611-1001376]
2015-02-27 FridayNo New Comments

Last: 2015-02-28 12:55:43
-
PL/SQL Explore

Records: Record Parameters

You can define a parameter with a record type, declared with %ROWTYPE or through an explicit RECORD statement. It's a good way to shrink the number of arguments that have to be passed to a subprogram.

Author: Steven Feuerstein [10596-995129]
2015-02-20 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

How PL/SQL Resolves Identifier Names: Qualified Names and Dot Notation

You can always qualify the references to parameters and local variables with the name of the subprogram in which they are defined, as in my_proc.my_parm.

Author: Steven Feuerstein [10586-988863]
2015-02-20 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

Logical Operators: Short-Circuit Evaluation

When evaluating a logical expression, PL/SQL uses short-circuit evaluation. This means that PL/SQL stops evaluating as soon as the result can be determined, thereby improving efficiency of the code.

Author: Scott Wesley (40379) [2541-995130]
2015-02-20 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

NULL-Related Functions: NULLIF

Use NULLIF to return NULL if the two values passed to it are equal. Otherwise, it will return the first value.

Author: Steven Feuerstein [6433-987417]
2015-02-13 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

Character Functions Returning Character Values: SUBSTR

SUBSTR's three arguments offer lots of flexibility when parsing strings.

Author: Steven Feuerstein [10583-987416]
2015-02-13 FridayNo New Comments

Last: 2015-02-10 11:27:31
-
PL/SQL Explore

INDEX BY Options for Associative Arrays: Declaring a string-indexed associative array

When you index an associative array by VARCHAR2, you can end up with some unexpected behavior if you are not careful about the values assigned for the indexes.

Author: Steven Feuerstein [10584-987446]
2015-02-13 FridayNo Comments
Last: No Comments
-
PL/SQL Explore

FORALL: SQL%BULK_ROWCOUNT

With FORALL, SQL%ROWCOUNT tells you the total number of rows modified for the entire FORALL statement, while you can use SQL%BULK_ROWCOUNT to find out how many rows were modified by each DML statement generated by FORALL and passed to the SQL engine.

Author: Steven Feuerstein [10562-979516]
2015-02-06 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

CASE in PL/SQL: Matching on NULL in WHEN Clause

When you need to check for and match on a NULL value in your CASE statement or expression, you need to use a searched, not simple, CASE format. In other words, "WHEN IS NULL" will not work in CASE.

Author: Steven Feuerstein [7471-972507]
2015-02-06 FridayNo New Comments

Last: 2013-03-28 12:00:48
-
PL/SQL Challenge

Iterating Through Collection Elements: Iterating Through Sparse Collections

When working with sparse collections (not every element between FIRST and LAST defined), you will probably find the associative array to be the best "fit."

Author: Steven Feuerstein [10522-972506]
2015-02-06 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

Oracle Exceptions: VALUE_ERROR exception

The VALUE_ERROR exception (ORA-06502) is raised under (generally) three circumstances: you try to stuff too big a value into too small a container; you try to assign a non-numeric value to a number; you try to assign NULL to a non-NULL variable.

Author: Steven Feuerstein [10486-965075]
2015-01-30 FridayNo New Comments

Last: 2015-02-04 05:43:59
-
PL/SQL Deja Vu

CASE in PL/SQL: Use of ELSE clause in CASE

In a CASE ... END CASE statement with no ELSE, "ORA-06592: CASE not found while executing CASE statement" is raised if the CASE expression is not matched by any of the WHEN clauses.

Author: Michael Brunstedt (11875) [2327-965077]
2015-01-30 FridayNo Comments
Last: No Comments
-
1 - 15 Next