VF=>user  ID=>     Login Register
Feedback   FAQ   Blog
877,538 quizzes played * 1,104 active players * US$68,737 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 Deja Vu

Numeric Functions: FLOOR

The FLOOR function returns the largest integer that is equal to or less than the number passed to it as its single argument.

Author: Steven Feuerstein [4122-886519]
2014-11-14 FridayNo Comments
Last: No Comments
-
PL/SQL Explore

SQL%ROWCOUNT: SQL%ROWCOUNT after EXECUTE IMMEDIATE

The value of SQL%ROWCOUNT is ensured to be accurate only if checked immediately after performing a DML statement.
After executing a dynamic DML statement using EXECUTE IMMEDIATE, the value of SQL%ROWCOUNT will be similar to the one it has after a similar static DML statement. On the other hand, after using EXECUTE IMMEDIATE for executing a dynamic PL/SQL block, the value of SQL%ROWCOUNT will depend on the mode of the bind variables passed to the dynamic PL/SQL block (IN, OUT, IN OUT).

Author: mentzel.iudith (70892) [10164-872569]
2014-11-14 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

Expressions and Comparisons: Boolean Expressions

You can perform some operations on Booleans, including equality and inequality checks - but also a greater than or less than check!

Author: Steven Feuerstein [10204-881482]
2014-11-14 FridayNo Comments
Last: No Comments
-
PL/SQL Explore

DBMS_UTILITY: WAIT_ON_PENDING_DML

The WAIT_ON_PENDING_DML function in the DBMS_UTILITY package forces the current Oracle session to pause and wait for any uncommitted DML (database wide) on a specified table to be committed or rolled back. If the uncommitted DML is committed or rolled back within the specified time limit then the function returns TRUE. If the specified timeout is exceeded before the uncommitted DML is committed or rolled back then FALSE is returned.

Author: Darryl Hurley (4605) [10141-872534]
2014-11-07 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

Object Types: Object Type Hierarchies

To define a hierarchy of object types, you must make sure to define all supertypes (those types not at the "bottom" of the hierarchy) as NOT FINAL. All subtypes should then be defined as UNDER its parent.

Author: Steven Feuerstein [5917-879253]
2014-11-07 FridayNo New Comments
Objections: ACCEPTED
Last: 2012-05-02 21:25:59
-
PL/SQL Challenge

Character Functions Returning Character Values: SUBSTR

SUBSTR offers lots of flexibility if you fully understand and utilize all of its arguments.

Author: Steven Feuerstein [10202-879252]
2014-11-07 FridayNo New Comments

Last: 2014-11-05 17:28:45
-
PL/SQL Explore

Fundamentals: Scope and Visibility of Identifiers

A cursor has scope, just like a variable or constant. Declared it at the package level, its scope is the session, and it will stay open until you explicitly close it, your session ends, or you have defined the package to be serially reusable. If you define a cursor locally in a block, then Oracle will automatically close that cursor when the block terminates.

Author: Steven Feuerstein [10163-871495]
2014-10-31 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

Working with collection variables: Assigning Values to Collections

When working with nested tables and varrays, you can call a constructor function to initialization your collection - and you can do this in the declaration section. With associative arrays, you must assign element values in the executable section - or in a function previously defined.

Author: Steven Feuerstein [10143-871494]
2014-10-31 FridayNo New Comments

Last: 2014-11-08 05:37:36
-
Oracle Magazine Quiz

Anchoring declarations to existing types: SUBTYPE to Define Subsets of Datatypes

When working with nested and string-indexed collections, rely heavily on SUBTYPEs to improve the readability of the type declarations.

Author: Steven Feuerstein [9641-776546]
2014-10-31 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

DBMS_SQL: DBMS_SQL.RETURN_RESULT

RETURN_RESULT was added to DBMS_SQL in 12.1 to make it easier to migrate TransactSQL code to PL/SQL - it will "implicitly" retrieve and display the set of data identified by the cursor variable.

Author: Steven Feuerstein [8353-871496]
2014-10-31 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

Numeric Data Types : SIMPLE_INTEGER

SIMPLE_INTEGER, which offers optimized performance over PLS_INTEGER when code is compiled natively, also differs from all BINARY_INTEGER-related types in both overflow semantics (it wraps instead of raising an overflow error) and a NOT NULL constraint.

Author: Steven Feuerstein [10122-863943]
2014-10-24 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

Embedding Single Quotes in String Literals: Q notation for string literals

The q notation offers an alternative way of defining string literals, most helpful when that literal has within it single quotes.

Author: Keith Hollins (10609) [2742-863944]
2014-10-24 FridayNo Comments
Last: No Comments
-
PL/SQL Explore

UTL_CALL_STACK: Using UTL_CALL_STACK to show the error backtrace

The utl_call_stack package, new in Oracle 12c, offers you a structured interface (API) to information that in earlier versions was available only by a call to dbms_utility.format_error_backtrace.

Author: Jeroen Rutte (26657) [8748-863948]
2014-10-24 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

Calling PL/SQL Functions from SQL: Behavior When Function Raises NO_DATA_FOUND

When a function that is called in an SQL statement propagates out an unhandled NO_DATA_FOUND exception, the calling query acts as though the function returned a NULL value.

Author: Jan Leers (iAdvise.be) (5328) [3085-856657]
2014-10-17 FridayNo Comments
Last: No Comments
-
PL/SQL Challenge

Parameters: Default Values

Add a DEFAULT clause to a parameter to allow the subprogram to be called without specifying a value for that parameter. But NULL can still be passed for that parameter, so you may also need to use NVL inside the subprogram to convert the NULL value to something else. 

Author: Steven Feuerstein [10086-856654]
2014-10-17 FridayNo Comments
Last: No Comments
-
1 - 15 Next