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 62 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


DML Reference, 10g Release 1 (10.1)

NVL

NVLThe NVL function replaces a NA value with a string. To evaluate a specified expression and replace … type of the base expression. Syntax NVL ( exp, replacement-exp ) Arguments expr The expression that you

SQL Reference, 10g Release 1 (10.1)

NVL

NVLSyntax nvl::= Description of the illustration nvl.gif Purpose NVL lets you replace (returned … as a blank) with a string in the results of a query. If expr1 is , then NVL returns expr2. If … expr1 is not , then NVL returns expr1. The arguments expr1 and expr2 can have any datatype. If … last_name, NVL(TO_CHAR(commission_pct),

SQL Reference, 10g Release 1 (10.1)

Nulls

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

DML Reference, 10g Release 1 (10.1)

18 MONITOR to NVL2

18 MONITOR to NVL2NASPELL NEW_TIME NEXT_DAY NLS Options NONE NORMAL NOSPELL NPV NULLIF NUMBYTES NUMCHARS NUMLINES NVL NVL2

Utilities, 10g Release 1 (10.1)

9 Field List Reference

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

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

2 Precompiler Concepts

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

Pro*FORTRAN® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Writing a Pro*FORTRAN Program

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

SQL Reference, 10g Release 1 (10.1)

Comments

Comments Within SQL Statementsstatements contain many comments: SELECT last_name, salary + NVL(commission_pct, 0), job_id, e.department_id … = d.department_id AND salary + NVL(commission_pct,0) > /* Subquery: */ (SELECT salary + NVL … = 'Pataballa'); SELECT last_name, -- select the name salary + NVL(commission_pct, 0),-- total compensation

Pro*PL/1® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

1 Writing a Pro*PL/1 Program

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

DML Reference, 10g Release 1 (10.1)

NVL2

NVL2, use NVL. Return Value The data type of the return value is always the data type of expr2 (that is

User's Guide and Reference, 10g Release 1 (10.1)

2 Fundamentals of the PL/SQL Language

Assigning a SQL Query Result to a PL/SQL Variable); BEGIN SELECT last_name, salary + (salary * nvl(commission_pct,0)) INTO emp_name, wages FROM

Packages and Types Reference, 10g Release 1 (10.1)

24 DBMS_DATA_MINING_TRANSFORM

INSERT_CLIP_TRIM_TAIL Procedure= val(N-floor(*N*q)) rval = NULL where q = ABS(NVL(tail_frac,0)). Nothing is done when q >= 0.5.

Packages and Types Reference, 10g Release 1 (10.1)

24 DBMS_DATA_MINING_TRANSFORM

INSERT_CLIP_WINSOR_TAIL Procedure-floor(N*q)) rval = rcut where q = ABS(NVL(tail_fraq,0)). Nothing is done when q >= 0.5.

Concepts, 10g Release 1 (10.1)

5 Schema Objects

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

Application Developer's Guide - Expression Filter, 10g Release 1 (10.1)

7 Object Types

EXF$INDEXOPERwith the equality predicate through the IS NOT NULL predicate NVL Predicates with NVL (equality

Advanced Replication Management API Reference, 10g Release 1 (10.1)

10 Monitoring a Replication Environment

Monitoring Master Groupsadminreqerror 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 WHERE

DML Reference, 10g Release 1 (10.1)

A.4 Statements for Working with NA Values

A.4 Statements for Working with NA Valuesany NA values appearing as the specified fill expression. NVL Replaces a NA value with a string

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

Filling Gaps in Data… The four added rows each have 0 as their Sales value set to 0 by using the NVL function. SELECT … Product_Name, t.Year, t.Week, NVL(Sales,0) dense_sales FROM (SELECT SUBSTR(p.Prod_Name,1,15

User's Guide and Reference, 10g Release 1 (10.1)

10 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 … / NVL(earnings, 0) INTO pe_ratio FROM stocks WHERE symbol = 'XYZ'; EXCEPTION WHEN ZERO_DIVIDE THEN

SQL Reference, 10g Release 1 (10.1)

About SQL Conditions

About SQL Conditionsdetermines whether the sum is greater than the number constant 25000: NVL(salary, 0) + NVL(salary