How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
VARCHAR2 → The VARCHAR2 datatype is a variable-length string of characters with a maximum length of 4000 bytes … format. If the VARCHAR2 string contains an illegal conversion character, Oracle returns an error and
B CHAR versus VARCHAR2 Semantics → This appendix explains the semantic differences between the CHAR and VARCHAR2 base types. These
Assigning Character Values → When you assign a character value to a VARCHAR2 variable, if the value is shorter than the declared … declared length of the VARCHAR2 variable, PL/SQL aborts the assignment and raises VALUE_ERROR. PL/SQL
Inserting Character Values → character value into a VARCHAR2 database column, Oracle does not strip trailing blanks. If the value is … RTRIM, which trims trailing blanks. An example follows: DECLARE... my_name VARCHAR2(15); BEGIN
Selecting Character Values → the assignment and raises VALUE_ERROR. When you select a column value into a VARCHAR2 variable, if … example, when you select a blank-padded CHAR column value into a VARCHAR2 variable, the trailing blanks … are not stripped. If the character value is longer than the declared length of the VARCHAR2 variable
Assigning Character Values → Comparing Character Values Inserting Character Values
Comparing Character Values → declarations last_name1 VARCHAR2(10):= 'COLES'; last_name2 VARCHAR2(10):= 'COLEMAN'; the following IF … VARCHAR2, non-blank-padding semantics are used. That is, when comparing character values of unequal … last_name1 VARCHAR2(10):= 'DOW'; last_name2 VARCHAR2(10):= 'DOW '; -- note trailing blanks the
VARCHAR2 (weightstring) → A list of weights to apply to each visual attribute. Data type is VARCHAR2. The following
VARCHAR2 and VARCHAR Datatypes → The VARCHAR2 datatype stores variable-length character strings. When you create a table with a … VARCHAR2 column, you specify a maximum string length (in bytes or characters) between 1 and 4000 bytes … for the VARCHAR2 column. For each row, Oracle stores each value in the column as a variable-length … VARCHAR2
VARCHAR2 and VARCHAR → NVARCHAR2 NUMBER DATE
LONG, RAW, LONG RAW, VARCHAR2 → You can use the piecewise capabilities provided by OCIBindByName(), OCIBindByPos(), OCIDefineByPos(), OCIStmtGetPieceInfo() and OCIStmtSetPieceInfo() to perform inserts, updates or fetches involving column data of these types.
SDO_INDEX_NAME VARCHAR2 Name of the index. → SDO_INDEX_TYPE VARCHAR2 Contains QTREE (for a quadtree index) or RTREE (for an R-tree index). SDO_INDEX_NAME VARCHAR2 Name of the index.
UNICODE Support for VARCHAR2 and CLOB → In this release, database UNICODE support for VARCHAR2s [unicode] provides a few UNICODE variants on functions INSTR, SUBSTR, LENGTH, and LIKE. These UNICODE functions are not yet supported on CLOBs or NCLOBs as summarized in Table 7-7. See Also: Oracle9i Supplied PL/SQL Packages and Types Reference Oracle9i Application Developer's Guide - Fundamentals Oracle9i SQL Reference Oracle9i Database Globalization
Implicit Conversions Between CLOB and VARCHAR2 → The implicit conversion in both directions, from CLOB to VARCHAR2, and from VARCHAR2 to CLOB, have … into VARCHAR2 PL/SQL variables VARCHAR2 columns can be selected into CLOB variables Assignment and parameter passing between CLOBs and VARCHAR2s
Accepting CLOBs in VARCHAR2 Operators/Functions → SQL operators/functions that currently take VARCHAR2 columns as operands or arguments are now
VARCHAR2 and CLOB in PL/SQL Built-in Functions → CLOB and VARCHAR2 are still two distinct types. But depending on the usage, a CLOB can be passed to … SQL and PL/SQL VARCHAR2 built-in functions, behaving exactly like a VARCHAR2. Or the variable can … , "PL/SQL Example 4: CLOB Variables in PL/SQL". PL/SQL VARCHAR2 functions/operators need to take CLOBs … as argument
SDO_INITIAL_EXTENT VARCHAR2 Same as in SQL CREATE TABLE statement. → SDO_TABLESPACE VARCHAR2 Same as in the SQL CREATE TABLE statement. Tablespace in which to create … the SDOINDEX table. SDO_INITIAL_EXTENT VARCHAR2 Same as in SQL CREATE TABLE statement.
How Globalization Settings Affect VARCHAR2 Keys for Associative Arrays → arrays with VARCHAR2 key values, the program might encounter a runtime error. For example, changing … must use a VARCHAR2, STRING, or LONG type. You can use a different type, such as NCHAR or NVARCHAR2, as … it can be converted to VARCHAR2 by the TO_CHAR function. However, you must be careful when using … same VARCHAR2
VARCHAR2 and CLOB in PL/SQL Built-In Functions → PL/SQL VARCHAR2 functions and operators take CLOBs as arguments or operands. A CLOB can be passed … to SQL and PL/SQL VARCHAR2 built-in functions, behaving exactly like a VARCHAR2. Or the VARCHAR2 … operators (>, =, <,!=) If a function returns a CLOB and the result is assigned to a VARCHAR2 variable