You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for NVL


1 to 20 of 57 results. Previous page Prev  Next next page
Results per page:   20  | 40


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 88 of 177

NVLSyntax nvl::= Text description of nvl Purpose NVL lets you replace a (blank) with a string in … the results of a query. If expr1 is , then NVL returns expr2. If expr1 is not , then NVL … employee receives no commission: SELECT last_name, NVL(TO_CHAR(commission_pct), 'Not Applicable

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

NULLIFNVL NVL2

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Defining Aliases for Expression Values in a Cursor FOR Loopselect item is an expression? Consider the following example: CURSOR c1 IS SELECT empno, sal+NVL(comm,0 … example, wages is an alias for the select item sal+NVL(comm,0): CURSOR c1 IS SELECT empno, sal+NVL(comm,0

SQL Reference, 9i Release 2 (9.2.0.2)

Basic Elements of Oracle SQL, 5 of 10

Nulls in SQL FunctionsAll scalar functions (except REPLACE, NVL, and CONCAT ) return when given a argument. You … can use the NVL function to return a value when a occurs. For example, the expression NVL(COMM

SQL Reference, 9i Release 2 (9.2.0.2)

Basic Elements of Oracle SQL, 7 of 10

Comments Within SQL Statementsset. Example These statements contain many comments: SELECT last_name, salary + NVL(commission_pct, 0 … .*/ WHERE e.department_id = d.department_id AND salary + NVL(commission_pct,0) > /* Subquery … : */ (SELECT salary + NVL(commission_pct,0) /* total compensation is salar + commission_pct */ FROM employees … WHERE last_name =

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Precompiler Concepts

NULLs in SQLzero nor to a blank. Use the NVL function to convert NULLs to non-NULL values, use the IS [NOT] NULL

Utilities, 9i Release 2 (9.2.0.2)

Field List Reference

Combinations of SQL Operators(:field1),'N/A', '0')" field1 CHAR(10) "NVL( LTRIM(RTRIM(:field1)), 'unknown' )"

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

Example, 'Oracle', 10) > 0 OR CONTAINS (news.body, 'java', 20) > 0 ORDER BY NVL(SCORE(10),0), NVL(SCORE(20),0);

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Writing a Pro*PL/I Program

Nullsneither to zero nor to a blank. Therefore, use either the NVL function, the IS [NOT] NULL operator

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Handling PL/SQL Errors

Branching to or from an Exception Handler: DECLARE pe_ratio NUMBER(3,1); BEGIN DELETE FROM stats WHERE symbol = 'XYZ'; SELECT price / NVL

Concepts, 9i Release 2 (9.2.0.2)

Schema Objects

Nulls Indicate Absence of Valuethe IS NULL predicate. Use the SQL function NVL to convert s to non- values. Nulls are not … : Oracle9i SQL Reference for more information about comparisons using IS NULL and the NVL function "Indexes and Nulls" "Bitmap Indexes and Nulls"

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 19 of 177

COALESCEevaluate to , then the function returns . This function is a generalization of the NVL function … COALESCE (expr2,..., exprn) END See Also: NVL and "CASE Expressions" Examples The following example uses

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Passing Parameters to a Cursor FOR Loopemp_cursor. */ FOR emp_record IN emp_cursor(20) LOOP emp_record.comm:= NVL(emp_record.comm, 0

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

Handling Null Values in Comparisons and Conditional Statements', 5000) INTO credit_limit FROM accts WHERE acctno = my_acctno; The function NVL returns the value of … its second argument if its first argument is . In the example below, if hire_date is , NVL … returns the value of SYSDATE. Otherwise, NVL returns the value of hire_date: start_date:= NVL

Replication Management API Reference, 9i Release 2 (9.2.0.2)

Monitoring a Replication Environment

Monitoring Master Groups' COLUMN adminreqerror FORMAT 9999 SELECT G.GNAME, NVL(T.CNT1, 0) deftran, NVL(IE.CNT2, 0) deftranerror … , NVL(A.CNT3, 0) adminreq, NVL(B.CNT4, 0) adminreqerror FROM (SELECT DISTINCT GNAME FROM DBA_REPGROUP

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Packages

About the DBMS_OUTPUT PackageLOOP c1rec.comm:= NVL(c1rec.comm, 0); payroll:= payroll + c1rec.sal + c1rec.comm; END LOOP

SQL Reference, 9i Release 2 (9.2.0.2)

Conditions, 2 of 13

About SQL Conditions) and determines whether the sum is greater than the number constant 2500: NVL(salary, 0) + NVL

Objects for OLE, 9i Release 2 (9.2.0.2)

GetField Method

GetField Method("ExampleDB", "scott/tiger", 0); // open an ODynaset ODynaset dyn; dyn.Open(odb, "select empno, ename, nvl … use the expression (which is the column name) OField commfield = dyn.GetField("nvl(comm,0

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Handling PL/SQL Errors

Continuing after an Exception Is Raisedsymbol = 'XYZ'; SELECT price / NVL(earnings, 0) INTO pe_ratio FROM stocks WHERE symbol = 'XYZ'; INSERT … ); BEGIN DELETE FROM stats WHERE symbol = 'XYZ'; BEGIN ---------- sub-block begins SELECT price / NVL

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Gathering Optimizer Statistics

Types of Histograms= 'Y' AND NVL(l.shipped_quantity, 0)=0 OR NVL(l.shipped_quantity, 0) != 0 AND l.shipped_quantity +NVL