VF=>user  ID=>     Login Register
Feedback   FAQ   Blog
917,562 quizzes played * 1,126 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 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 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

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 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 (79241) [10905-1096168]
2015-05-15 FridayNo New Comments

Last: 2015-05-20 17:24:03
-
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

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 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
-
Oracle Magazine QuizFeature and summary not shown till quiz has closed.

Author: Steven Feuerstein [10504-968813]

2015-04-30 ThursdayNo Comments
Last: No Comments
-
PL/SQL Challenge

How PL/SQL Resolves Identifier Names: Duplicate Identifier Names

Turns out you can declare more than one variable with the same name, as long as you do not reference that name (identifier) anywhere in your code. If you try to reference it then the PL/SQL compiler raises an error.

Author: Steven Feuerstein [10811-1067150]
2015-04-24 FridayNo New Comments

Last: 2015-04-27 09:12:48
-
PL/SQL Deja Vu

Conversion Functions: TO_DATE

When you call TO_DATE, the string that you want to convert to a date must be in the default date format or you must provide a format mask that matches the way the date is specified in the string. You can also specify some NLS date values, such as the language, for the third parameter of TO_DATE, but you cannot specify the format through this parameter.

Author: Steven Feuerstein [7280-1067280]
2015-04-24 FridayNo New Comments

Last: 2013-02-06 20:03:50
-
1 - 15 Next