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 NULL


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


SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

NULL *NUMBER

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Objects

NULL IndicatorsC structures representing the NULL status of object types are generated by the Object Type … . Other Oracle types do not require special treatment for NULL indicators. Se Also: "Datatypes and … Host Variables" for more information about NULL indicators. Because object types have internal … structure, NULL indicators

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

PL/SQL Language Elements, 31 of 52

NULL StatementThe NULL statement explicitly specifies inaction; it does nothing other than pass control to the … next statement. In a construct allowing alternative actions, the NULL statement serves as a placeholder. For more information, see "NULL Statement".

SQL Reference, 9i Release 2 (9.2.0.2)

Conditions, 7 of 13

Null ConditionsA NULL condition tests for s. _condition::= Text description of _condition Table 5-9 … lists the conditions. Table 5-9  Null Conditions Type of Condition Operation Example IS [NOT … ] NULL Tests for s. This is the only condition that you should use to test for s. See Also … : "Nulls" SELECT last_name FROM employees

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

Key Programming Considerations

Null-HandlingJava primitive types (such as int, double, or float ) cannot have values, which you must

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

PL/SQL Control Structures

NULL StatementThe NULL statement does nothing other than pass control to the next statement. In a conditional … construct, the NULL statement tells readers that a possibility has been considered, but no action is … necessary. In the following example, the NULL statement shows that no action is taken for unnamed … ... COMMIT; WHEN OTHERS THEN

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

Implementing Dynamic SQL Method 4

Handling NULL/NOT NULL DatatypesDESCRIBE returns a NULL/NOT NULL indication in the SQLDVTYP element of the select descriptor … , defined as a FIXED BINARY (15). If a column is declared to be NOT NULL, the high-order bit of the … NULL/NOT NULL bit is set, you must clear it. (Never set the bit.) You can use the library procedure

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

Oracle Dynamic SQL: Method 4

Handling NULL/Not NULL DatatypesFor every select-list column (not expression), DESCRIBE SELECT LIST returns a NULL/not NULL … be not NULL, the high-order bit of SELDVTYP(J) datatype variable is clear; otherwise, it is set … . Before using the datatype in an OPEN or FETCH statement, if the NULL status bit is set, you must clear … it. Never set

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL: Method 4

Handling NULL/Not NULL DatatypesFor every select-list column (not expression), DESCRIBE SELECT LIST returns a NULL/not NULL … to be not NULL, the high-order bit of T[ i ] is clear; otherwise, it is set. Before using the … datatype in an OPEN or FETCH statement, if the NULL/not NULL bit is set, you must clear it. (Never set the

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

Relational Programming

Null and Truncated Datamethods of the ResultSet class or Statement class is or truncated. However, this behavior can be … methods are called with causeException=TRUE, then an SQLException is raised when a data value is or … truncated. The default behavior is to not raise an SQLException. In this case, data is returned … as zero (0) for numeric values

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

Accessing and Manipulating Oracle Data

Converting SQL NULL DataJava represents a SQL NULL datum by the Java value . Java datatypes fall into two categories … cannot represent . Instead, they store the as the value zero (as defined by the JDBC … types can represent . The Java language defines an object wrapper type corresponding to every … primitive type

Application Developer's Guide - Object-Relational Features, 9i Release 2 (9.2.0.2)

Basic Components of Oracle Objects

Null Objects and AttributesA table column, object, object attribute, collection, or collection element is NULL if it has been … initialized to NULL or has not been initialized at all. Usually, a NULL value is replaced by an … actual value later on. An object whose value is NULL is called atomically . An atomically

Migration, 9i Release 2 (9.2.0.2)

Upgrading an Oracle7 Database Using the MIG Utility

found NULL SQL statementCause: An internal error has occurred; the migrate.bsq script may be corrupted. Action: Check that the version of the MIG utility, of migrate.bsq, and of the Oracle9 i software are compatible, and that no corruption exists in migrate.bsq. Fix any problems and rerun the MIG utility.

Concepts, 9i Release 2 (9.2.0.2)

Data Integrity

NOT NULL Integrity ConstraintsBy default, all columns in a table allow s. Null means the absence of a value. A NOT NULL … constraint requires a column of a table contain no values. For example, you can define a NOT NULL … table. Figure 21-2 illustrates a NOT NULL integrity constraint. Figure 21-2 NOT NULL Integrity

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

SQLJ Error Messages

java.sql.SQLException: null connectionSQL State: 08000 Cause: A SQLJ connection context or JDBC connection object was passed to the

Programmer's Guide, 9i Release 2 (9.2.0.2)

The Object Type Translator (OTT)

Null Indicator Structscorresponding indicator struct. When an object type is selected into a C struct, indicator … information may be selected into a parallel struct. For example, the following indicator struct was … ; OCIInd the_raw; }; typedef struct many_types_ind many_types_ind; The layout of the struct is … important. The

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Command Reference

SET NULL textSets the text that represents a value in the result of a SQL SELECT command. Use the NULL … clause of the COLUMN command to override the setting of the NULL variable for a given column.

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Selecting Data, 12 of 13

Working with Null StatusYou can set the current status list of a dimension to (empty status) only when you have … explicitly specified that you want status to be permitted. You can give this permission in either of … two ways: Set the OKNULLSTATUS option to yes. This specification indicates that status should … NULL keyword in a LIMIT

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

Fundamentals of PL/SQL

Using NOT NULLBesides assigning an initial value, declarations can impose the NOT NULL constraint, as the … following example shows: acct_id INTEGER(4) NOT NULL:= 9999; You cannot assign s to a variable defined … as NOT NULL. If you try, PL/SQL raises the predefined exception VALUE_ERROR. The NOT NULL … allowed: acct_id INTEGER(5)

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

Key Programming Considerations

Examples of Null-HandlingThe following examples show the use of the java.lang wrapper classes to handle data. Example … : Null Input Host Variable In the following example, a Float object is used to pass a value to … = 7499; Float commission = ; #sql { UPDATE emp SET comm =:commission WHERE empno =:empno … }; Example: Null