VF=>user  ID=>     Login Register
Feedback   FAQ   Blog
878,670 quizzes played * 1,098 active players * US$69,112 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

DBMS_SCHEDULER: EVALUATE_CALENDAR_STRING

Complex schedules for DBMS_SCHEDULER can be built by creating multiple simpler named schedules and combining them.

Author: Kim Berg Hansen (23868) [10201-886577]
2014-11-21 FridayNo New Comments

Last: 2014-11-20 19:28:14
-
PL/SQL Challenge

Numeric Functions: MOD

Use MOD for a quick and easy way to check to see if an integer is even.

Author: Steven Feuerstein [10221-886576]
2014-11-21 FridayNo Comments
Last: No Comments
-
PL/SQL Deja Vu

Declaring and Calling Subprograms: Calling PL/SQL Functions from SQL

You can call a user-defined function anywhere inside an SQL statement that a bind variable can be referenced, as well as in the FROM clause of a query, in place of a table or view name. Specifically, you can call your function in/on any of the following: the SELECT list of the query as part of an expression; the WHERE clause of a query, update or delete; the right side of the SET clause of an update (that is, column = function() ); the expression list of an insert statement; the FROM clause of a query, when invoked within the TABLE operator (this sort of function is called a table function).

Author: Steven Feuerstein [1298-886578]
2014-11-21 FridayNo New Comments

Last: 2014-11-04 23:50:34
-
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 (71019) [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 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

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

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
-
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 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
-
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 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
-
1 - 15 Next