VF=>user  ID=>     Login Register
Feedback   FAQ   Blog
918,030 quizzes played * 1,129 active players * US$74,347 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
PL/SQL Explore

Limiting Rows for a Bulk FETCH Operation: The LIMIT clause

Whenever you FETCH BULK COLLECT with LIMIT, the contents of target collections are wiped clean and re-populated. If you keep fetching till a fetch returns no rows, the collection is them empty.

Author: Steven Feuerstein [11035-1120363]
2015-05-29 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

Error Message Functions: SQLERRM

SQLERRM expects a negative integer for the lookup of default error messages, but FORALL SAVE EXCEPTIONS and LOG ERRORS both record unsigned/positive integers.

Author: Steven Feuerstein [11033-1117459]
2015-05-29 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

Analyze size and memory consumption of programs: Techniques to Reduce PGA Consumption

Process Global Area memory is consumed on a per session basis, so it doesn't "scale" well. If you encounter an out-of-memory error, you should investigate PGA-reducing techniques, including BULK COLLECT with LIMIT, pipelined table functions and VARCHAR2 sizes.

Author: Steven Feuerstein [8966-1117460]
2015-05-29 FridayNo New Comments

Last: 2014-02-28 14:40:11
-
PL/SQL Deja Vu

Referencing Inquiry Directives inside Conditional Compilation Statements: Referencing Undefined Inquiry Directives

Conditional compilation selection directives ($IF) can reference inquiry directives (also known as conditional compilation flags) using the "$$" prefix. If the flag has not been set with an ALTER SESSION or ALTER PROCEDURE command, then any reference to the flag simply evaluates to NULL.

Author: Steven Feuerstein [2466-1105763]
2015-05-22 FridayNo Comments
Last: No Comments
-
PL/SQL Explore

NOCOPY Parameter Hint: Unhandled Exceptions Effect on NOCOPY Parameters

Whenever you use NOCOPY, be sure to evaluate the effects of an unhandled exception: will partially changed data structures cause any kind of problem in your code?

Author: Steven Feuerstein [11006-1105777]
2015-05-22 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

Working with collection variables: Sorting collection contents

Need to order contents of your array different from the index? Consider using the TABLE operator or a string-indexed array.

Author: Steven Feuerstein [11005-1105762]
2015-05-22 FridayNo Comments
Last: No Comments
-
PL/SQL Explore

Dependency Management in Result Caches: Remote objects dependencies

When a PL/SQL function defined with RESULT_CACHE or a query with he RESULT_CACHE hint retrieves data from a remote table, accessed through a database link, then the remote table is NOT registered as a dependency for the function. As a result, committed changes performed on the remote table do not cause the cached result to be invalidated, as is the case when the function depends on a local table. Instead, the cached result remains valid for a time interval determined by the result_cache_remote_expiration parameter. The default value of this parameter is 0 minutes, which means expiring immediately.
 

Author: mentzel.iudith (79293) [10905-1096168]
2015-05-15 FridayNo New Comments

Last: 2015-05-20 17:24:03
-
PL/SQL Challenge

Expressions and Comparisons: LIKE Clause with Wildcard

The wildcard symbols "_" (any single character) and "%" (any number of characters) come in very handy when comparing strings.

Author: Steven Feuerstein [10981-1096179]
2015-05-15 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

Datetime Functions: TRUNC (date)

Watch out for the IW format because that might bring you back to the previous month.

Author: Jeroen Rutte (29961) [9661-1096180]
2015-05-15 FridayNo New Comments

Last: 2014-08-05 13:56:07
-
PL/SQL Deja Vu

Run-time catching of overloading errors: Impact of Default Values on Overloading

When overloading packaged subprograms, keep in mind that if parameters have default values, you may run into "PLS-00307: too many declarations of 'program_name' match this call". errors when you try to call a subprogram in a way that uses default values.

Author: Steven Feuerstein [1817-1085533]
2015-05-08 FridayNo Comments
Last: No Comments
-
PL/SQL Explore

Working with Object Type Instances: Initializing Instances Before Use

You can take many approaches to populating the attributes of an object type, including within a call to a constructor function, something you are not able to do with records.

Author: Steven Feuerstein [10941-1093233]
2015-05-08 FridayNo New Comments
Objections: REJECTED
Last: 2015-05-04 00:06:10
-
PL/SQL Challenge

Character Data Types : Fixed-Length Strings (CHAR)

When working with fixed-length strings, keep in mind that values are right-padded with spaces to the length specified in the variable's declaration.

Author: Steven Feuerstein [10942-1087502]
2015-05-08 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

Built-in Functions: Aggregate Functions

You can define your own aggregate functions, that can be called within an SQL statement, by creating an object type with member functions whose names and parameter lists meet specific Oracle conventions.

Author: Randy Gettman (33459) [3086-1075090]
2015-05-01 FridayNo Comments
Last: No Comments
-
PL/SQL Explore

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

When you write a CASE statement, be sure to include an ELSE clause, otherwise if no match is found, your block will fail with "ORA-06592: CASE not found while executing CASE statement". CASE expressions will simply return NULL under that scenario

Author: Steven Feuerstein [10864-1075094]
2015-05-01 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

Implicit Cursors: Attributes of SQL (Implicit) Cursors

The SQL% cursor attributes do not reflect the state of cursor variables opened in your block.

Author: Steven Feuerstein [10863-1075089]
2015-05-01 FridayNo Comments
Last: No Comments
-
1 - 15 Next