VF=>user  ID=>     Login Register
Feedback   FAQ   Blog
866,789 quizzes played * 1,159 active players * US$68,287 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

How PL/SQL Resolves Identifier Names: Overriding Standard Function names

Static SQL statements or PL/SQL blocks resolve object names differently than similar statements executed dynamically inside the same package, so, a same name referenced by a static or dynamic statement can be resolved to a different object. Also, functions having the same name as a standard built-in functions are resolved differently by SQL and PL/SQL statements.

Author: mentzel.iudith (69533) [9843-844134]
2014-09-26 Friday-No New Comments

Last: 2014-09-29 19:05:07
PL/SQL Deja Vu

Guidelines for Optimizing Performance: Avoid SELECT from DUAL Queries

There are very few reasons to SELECT from DUAL in PL/SQL programs in modern versions of the Oracle Database. If you ever see such a query in a PL/SQL program unit, make sure it is justified. If not, replace with a native PL/SQL computation and assignment.

Author: Steven Feuerstein [8944-843086]
2014-09-26 Friday-No New Comments
Objections: REJECTED
Last: 2014-09-26 20:36:45
PL/SQL Challenge

Scalar Data Types : Numeric Data Types

There is almost always more than one way to implement a requirement. Aim for minimal complexity and maximum readability. And make sure it performs well enough to meet user needs.

Author: Steven Feuerstein [10001-843085]
2014-09-26 Friday-No Comments
Last: No Comments
PL/SQL Explore

Built-in (Supplied) Packages and Types: DBMS_SYS_SQL

DBMS_SYS_SQL works just like DBMS_SQL, except that in place of PARSE there is a PARSE_AS_USER procedure that allows you to parse a SQL statement as if you were another user in the database. IN other words, the statement executes with that user's privileges. The privilege to execute this package should be very strictly controlled.

Author: Steven Feuerstein [8287-834670]
2014-09-19 Friday-No Comments
Last: No Comments
PL/SQL Deja Vu

OUT Mode: OUT argument NULL if not set

If you do not assign a value to an OUT parameter in your subprogram, Oracle will set it to NULL. Also, Oracle will let you "read" an OUT parameter's value, but it will be NULL until you assign it a value in the subprogram.

Author: Steven Feuerstein [6694-834669]
2014-09-19 Friday-No Comments
Last: No Comments
PL/SQL Challenge

Raising Exceptions: Avoid raising exceptions

If you can anticipate that a certain exception could or is likely to be raised in your code, then either trap that exception by name or, even better, write code to avoid the exception ever being raised. Exception raising and handling slows your program down significantly.

Author: Steven Feuerstein [9947-834668]
2014-09-19 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 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 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

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
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 (14601) [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
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 (32988) [9846-811744]
2014-08-29 Friday-No Comments
Last: No Comments
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
1 - 15 Next