The Knowledge Center includes thousands of Online Courses, Recorded WebClasses and Recorded WebSeminars with topics covering Oracle, PeopleSoft and JD Edwards products. Gain access to:

• Oracle product specific titles which include tutorials from Oracle experts, quizzes, demonstrations, practices and simulations
• PeopleSoft and JD Edwards product specific titles which include simulations, demonstrations and tutorials
• Instructor led training equivalent courses
• Reference materials to supplement instructor led training materials such as additional hands on practices
• Certification exam preparation
• Specialty topics not covered within OU's instructor led training courses

In Oracle 9i, you can use the case statement within an SQL statement. It has the functionality of an IF-THEN-ELSE statement.

The syntax for the case statement is:

CASE expression
WHEN condition_1 THEN result_1
WHEN condition_2 THEN result_2
...
WHEN condition_n THEN result_n
ELSE result END

expression is the value that you are comparing to the list of conditions. (ie: condition_1, condition_2, ... condition_n)

condition_1 to condition_n must all be the same datatype. Conditions are evaluated in the order listed. Once a condition is found to be true, the case statement will return the result and not evaluate the conditions any further.

result_1 to result_n must all be the same datatype. This is the value returned once a condition is found to be true.

Linux is about more than software—it's about getting the performance, reliability and world-class support you deserve. That's why you need SUSE Linux Enterprise 10 from Novell. It's a platform for the entire open enterprise, delivering new Linux solutions that help you outperform competitors, cut costs, neutralize security threats. You need a Linux platform that is rock-solid and enterprise-grade; one that easily plugs into your existing infrastructure; and one that's secure, simple to manage and easy to use. SUSE Linux Enterprise is the best-engineered, most interoperable platform for enterprise computing, fully supported by a vendor that understands your business needs. Come see what SUSE Linux Enterprise can do for you.

In Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement.

The syntax for the decode function is:

decode( expression , search , result [, search , result]... [, default] )

expression is the value to compare.

search is the value that is compared against expression.

result is the value returned, if expression is equal to search.

default is optional. If no matches are found, the decode will return default. If default is omitted, then the decode statement will return null (if no matches are found).

In Oracle/PLSQL, the NVL2 function extends the functionality found in the NVL function. It lets you substitutes a value when a null value is encountered as well as when a non-null value is encountered.

The syntax for the NVL2 function is:

NVL2( string1, value_if_NOT_null, value_if_null )

string1 is the string to test for a null value.

value_if_NOT_null is the value returned if string1 is not null.

value_if_null is the value returned if string1 is null.