VF=>user  ID=>     Login Register
Feedback   FAQ   Blog
864,217 quizzes played * 1,184 active players * US$68,427 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
%
Correct
Commentary
PL/SQL Explore

Built-in (Supplied) Packages and Types: SQL Translation Framework

SQL Translation Framework introduced in Oracle 12c does exactly what its name implies - it translates SQL strings. Strings to translate are defined using the DBMS_SQL_TRANSLATOR package. Then when Oracle encounters a matching SQL statement it translates it before execution.

Author: Darryl Hurley (4561) [9923-828706]
2014-09-12 Friday-No New Comments

Last: 2014-09-17 12:29:08
PL/SQL Deja Vu

Bulk Processing with FORALL and BULK COLLECT: BULK COLLECT - Multiple Row Selects

When you populate a nested table or varray with a BULK COLLECT query, you do not need to initialize that collection, nor do you need to call the EXTEND method to define elements in that collection prior to the BULK COLLECT statement.

Author: Steven Feuerstein [5729-828707]
2014-09-12 Friday-No Comments
Last: No Comments
PL/SQL Challenge

Character Functions Returning Character Values: SUBSTR

If you need to "extract" individual characters from a string, use SUBSTR with a third argument value of 1.

Author: Steven Feuerstein [9928-828704]
2014-09-12 Friday-No New Comments

Last: 2014-09-15 05:07:44
PL/SQL Explore

Scalar Data Types : Numeric Data Types

Avoid using the BINARY_FLOAT or BINARY_DOUBLE data types when dealing with financial applications. You might end up magically gaining or losing values.

Author: Livio Curzola (14464) [9804-819348]
2014-09-05 Friday-No Comments
Last: No Comments
PL/SQL Challenge

Collections : Nested Tables

When working with nested tables and varrays, don't forget to initialize and extend before trying to assign values to elements in the collection.

Author: Steven Feuerstein [9882-819372]
2014-09-05 Friday-No Comments
Last: No Comments
PL/SQL Deja Vu

Types of Triggers: DDL Triggers

You can define triggers on DDL (data definition language) actions, either generically with an AFTER DDL or BEFORE DDL trigger, or by defining triggers on specific DDL statements.

Author: Steven Feuerstein [8037-819374]
2014-09-05 Friday-No New Comments

Last: 2014-09-04 16:52:50
Oracle Magazine QuizFeature and summary not shown till quiz has closed.

Author: Steven Feuerstein [9523-753122]

2014-08-31 Sunday-No Comments
Last: No Comments
PL/SQL Explore

Built-in Functions: XOR

XOR is the undocumented "Exclusive OR" boolean function. It can simplify expressions which require "Exclusive OR" logic since equivalent expression using only documented operators is complex and hard to understand. There is no equivalent operator.

Author: Elic (32609) [9846-811744]
2014-08-29 Friday-No Comments
Last: No Comments
PL/SQL Challenge

Continue past exceptions: SAVE EXCEPTIONS in FORALL

Use SAVE EXCEPTIONS to make sure all statements generated by the driving array(s) are executed. But remember: if at least one statement fails, then when FORALL is done, Oracle will raise the ORA-24381 error.

Author: Steven Feuerstein [9848-811742]
2014-08-29 Friday-No New Comments

Last: 2014-09-04 10:48:48
PL/SQL Deja Vu

Numeric Functions: TRUNC (number)

Oracle performs implicit conversions when necessary and appropriate. It also provides a TRUNC function that "truncates" both numbers and datetimes. If you pass a string to TRUNC, it always treat it as a number for purposes of implicit conversion.

Author: Steven Feuerstein [6858-811743]
2014-08-29 Friday-No New Comments
Objections: REJECTED
Last: 2012-09-27 23:18:23
PL/SQL Explore

Conversion Functions: TO_CHAR (datetime)

If you want to add "template" text inside the format mask supplied to TO_CHAR, you must surround it in double quotes.
Or you can concatenate that text around the converted date.

Author: Steven Feuerstein [9825-805435]
2014-08-22 Friday-No Comments
Last: No Comments
PL/SQL Deja Vu

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

Use the name of the scope in which a variable is declared (the name of the procedure or function, or even the name given to an anonymous/nested block with a label) to ensure that it is not confused with a SQL identifier, such as the name of the column.

Author: Jeff Kemp (17450) [2342-805434]
2014-08-22 Friday-No Comments
Last: No Comments
PL/SQL Challenge

Program Units: Functions

You can improve readability of code greatly by hiding complex expressions behind constants and/or functions. But be sure to carefully analyze the scope of these "hiders" and make sure that they will operate correctly under all circumstances.

Author: Steven Feuerstein [9824-805433]
2014-08-22 Friday-No Comments
Last: No Comments
PL/SQL Explore

Packages: Package invalidation and session state, the ORA-04068 error

Beware of the implications of invalidating stateful packages that are currently in use by active sessions.

Author: mentzel.iudith (68613) [4267-793931]
2014-08-15 Friday-No Comments
Last: No Comments
PL/SQL Deja Vu

Interval Literals: INTERVAL DAY TO SECOND Literals

DAY TO SECOND interval literals have limited support in PL/SQL. They should use one of the following syntax:

  • INTERVAL 'integer' [DAY|HOUR|MINUTE]
  • INTERVAL 'seconds [. frac_secs]' SECOND
  • INTERVAL '[+|-] days hours : minutes : seconds [. frac_secs]' DAY TO SECOND

Also PL/SQL does not allow specify precision of day and fractional seconds which are always maximum (=9).

Author: Elic (32609) [8513-793925]
2014-08-15 Friday-No New Comments

Last: 2013-12-03 12:11:45
1 - 15 Next