
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
Precompiler Options
VARCHAR → Purpose The VARCHAR option instructs Pro*COBOL to treat the COBOL group item described in Chapter 5 … , "Embedded SQL" as a VARCHAR datatype. Syntax VARCHAR={YES | NO} Default NO Usage Notes Cannot be … entered inline. When VARCHAR=YES, the implicit group item described in Chapter 5, "Embedded SQL" is … accepted
Datatypes
VARCHAR → The VARCHAR datatype stores character strings of varying length. The first two bytes contain the … the string in a bind or a define call must include the two length bytes, so the largest VARCHAR string … that can be received or sent is 65533 bytes long, not 65535. For converting longer strings, use the LONG VARCHAR external datatype.
Precompiler Options
VARCHAR → Purpose Instructs the Pro*C/C++ precompiler to interpret some structs as VARCHAR host variables … . Syntax VARCHAR={NO | YES} Default NO Usage Notes Can be entered only on the command line. When VARCHAR … precompiler as a VARCHAR[n] host variable. VARCHAR can be used in conjunction with the NLS_CHAR
Datatypes and Host Variables
VARCHAR Variables → string pseudotype called VARCHAR. A VARCHAR variable is a pseudotype that enables you to specify the
Datatypes and Host Variables
VARCHAR Variables → You can use the VARCHAR pseudotype to declare variable-length character strings. When your program … more convenient to use VARCHAR host variables instead of standard C strings. The datatype name VARCHAR … can be uppercase or lowercase, but it cannot be mixed case. In this Guide, uppercase is used to emphasize that VARCHAR
Embedded PL/SQL
VARCHAR Variables → When entering a PL/SQL block, Oracle9 i automatically checks the length fields of VARCHAR host
Datatypes
LONG VARCHAR → The LONG VARCHAR datatype stores data from and into an Oracle LONG column. The first four bytes of … a LONG VARCHAR contain the length of the item. So, the maximum length of a stored item is 2^31-5 bytes.
Embedded PL/SQL
VARCHAR Pseudotype → You can use the VARCHAR datatype to declare variable-length character strings. If the VARCHAR is an … component to the actual length of the value stored in the string component. If the VARCHAR is an output host … variable, Oracle automatically sets the length component. However, to use a VARCHAR (as well as
Embedded PL/SQL
VARCHAR Pseudotype → Recall that you can use the VARCHAR pseudotype to declare variable-length character strings. If the … VARCHAR is an input host variable, you must tell Pro*COBOL what length to expect. Therefore, set … the length field to the actual length of the value stored in the string field. If the VARCHAR is an … output host variable, Pro*COBOL
Datatypes and Host Variables
Declaring VARCHAR Variables → You define a VARCHAR host variable by adding the keyword VARYING to its declaration, as shown in … definitions that use VARYING. To see how to correctly use PIC N and PIC G in VARCHAR variables, see "Implicit … VARCHAR Group Items" The COBOL VARYING phrase is used in PERFORM and SEARCH statements to increment … example. VARCHAR
Native Datatypes
VARCHAR2 and VARCHAR Datatypes → VARCHAR2 and VARCHAR saves on space used by the table. For example, assume you declare a column … VARCHAR Datatype The VARCHAR datatype is synonymous with the VARCHAR2 datatype. To avoid possible changes
Advanced Topics
VARCHAR Variables and Pointers → The following example shows how VARCHAR host variables are declared: VARCHAR emp_name1[10 … ]; /* VARCHAR variable */ VARCHAR *emp_name2; /* pointer to VARCHAR */ On Input VARCHAR Variables When you use … a VARCHAR variable as an input host variable, your program need
Oracle and Informix Dynamic Server Compared
VARCHAR(m,r) → The Informix Dynamic Server VARCHAR datatype stores varying length single-byte and multibyte … case then, when migrating Informix Dynamic Server tables that contain VARCHAR columns consider … considered. For indexes based on VARCHAR columns, Informix Dynamic Server allocates the maximum storage … . Comparison Semantics Informix
Datatypes and Host Variables
VARCHAR Variable Referencing → In SQL statements, you reference VARCHAR variables using the struct name prefixed with a colon, as … the following example shows:... int part_number; VARCHAR part_desc[40];... main() {... EXEC SQL … in part_desc.arr. In C statements, you reference VARCHAR variables using the component names, as the … the length of the string before
Datatypes and Host Variables
Implicit VARCHAR Group Items → Pro*COBOL implicitly recognizes some group items as VARCHAR host variables when the precompiler … option VARCHAR=YES is specified on the command line. For variable-length single-byte character types … must be declared as level 49 for Pro*COBOL to recognize them as VARCHAR host variables. The VARCHAR … =YES command
Datatypes and Host Variables
Referencing VARCHAR Variables → In SQL statements, you reference a VARCHAR variable using the group name prefixed with a colon, as
Datatypes and Host Variables
VARCHAR Variable Declaration → Think of a VARCHAR as an extended C type or pre-declared struct. For example, the precompiler … expands the VARCHAR declaration VARCHAR username[20]; into the following struct with array and length … members: struct { unsigned short len; unsigned char arr[20]; } username; The advantage of using VARCHAR … variables
Creating a Logical Standby Database
VARCHAR2 and VARCHAR → NVARCHAR2 NUMBER DATE
Introduction
What is a VARCHAR? → Here is a short description of VARCHARs: VARCHAR Description VARCHAR2 A kind of column in the … ", because it is a possible column type. VARCHAR An Oracle "external datatype" (datatype code 9). You … use this only if you are doing dynamic SQL Method 4, or datatype equivalencing. VARCHAR[n] varchar[n
Running the Oracle Precompilers
VARCHAR → you want the precompiler to get needed information by connecting to Oracle and accessing the data dictionary, you must also specify USERID. VARCHAR
Datatypes and Host Variables
Insert NULLs Using VARCHAR Variables → If you set the length of a VARCHAR variable to zero before performing an UPDATE or INSERT statement
Basic Features
Streaming CHAR, VARCHAR, or RAW Columns → If you use the defineColumnType() Oracle extension to redefine a CHAR, VARCHAR, or RAW column as a … , because these columns are usually short. If you try to get a CHAR, VARCHAR, or RAW column as a data
Datatypes and Host Variables
Return NULLs to a VARCHAR Variable → Oracle automatically sets the length component of a VARCHAR output host variable. If you SELECT or … FETCH a NULL into a VARCHAR, the server does not change the length or array members. Note: If you … select a NULL into a VARCHAR host variable, and there is no associated indicator variable, an ORA
Datatypes and Host Variables
Pass VARCHAR Variables to a Function → functions by reference. The following example shows the correct way to pass a VARCHAR variable to a … function: VARCHAR emp_name[20];... emp_name.len = 20; SELECT ename INTO:emp_name FROM emp WHERE … ) VARCHAR *name; {... printf("name is %.*s\n", name->len, name->arr);... }
New Features
Implicit Form of VARCHAR Group Items → The declaration of COBOL groups that are recognized as VARCHAR are of the following format: nn 49 … range 1 to 65533. The VARCHAR=YES command line option must be specified for Pro*COBOL to recognize … the extended form of the VARCHAR group items. Otherwise, any declarations in the above format will be … interpreted as regular
Programming with Unicode
Using the VARCHAR Datatype in Pro*C/C++ → The Pro*C/C++ VARCHAR datatype is preprocessed to a struct with a length field and text buffer … field. The following example uses the C/C++ text native datatype and the VARCHAR Pro*C/C++ datatypes to … OPTION (CHAR_MAP=STRING). text ename[20]. /* unsigned short type */ varchar address[50]. /* Pro*C/C … use the VARCHAR
Datatypes and Host Variables
Find the Length of the VARCHAR Array Component → When the precompiler processes a VARCHAR declaration, the actual length of the array element in the … *C/C++ declaration VARCHAR my_varchar[12]; is expanded by the precompiler to struct my_varchar … () function the length of the data for a VARCHAR host variable or a VARCHAR pointer host variable, and … SQLVarcharGetLength()
Writing a Pro*FORTRAN Program
VARCHAR Variables → VARCHAR variables handle character data based on their roles as input or output variables On Input … When you use a VARCHAR variable as an input host variable, your program must assign values to the
Using Embedded PL/SQL
VARCHAR Pseudotype → ; VARCHAR Pseudotype Recall from Chapter 3, "Meeting Program Requirements" that you can use the … VARCHAR pseudotype to declare variable-length character strings. If the VARCHAR is an input host variable … value stored in the string field. If the VARCHAR is an output host variable, Oracle automatically … sets
Meeting Program Requirements
VARCHAR Variables → ; For more information about using host variables, see "Using Host Variables". VARCHAR Variables You … can use the VARCHAR pseudotype to declare variable-length character strings. (A pseudotype is a … datatype not native to your host language.) Recall that VARCHAR variables have a 2-byte length field … followed by a string field.
Writing a Pro*FORTRAN Program
VARCHAR Variables → When entering a PL/SQL block, Oracle automatically checks the length fields of VARCHAR host
Writing a Pro*FORTRAN Program
Referencing VARCHAR Variables → * Declare a VARCHAR. EXEC SQL BEGIN DECLARE SECTION VARCHAR*,, EXEC SQL END DECLARE SECTION where … : n Is the maximum length of the VARCHAR; n must be in the range 1 through 32765. VARNAM Is the name … used to reference the VARCHAR in SQL statements; it is called an aggregate name because it … VARCHAR
Writing a Pro*FORTRAN Program
Declaring VARCHAR Variables → A VARCHAR is a set of three variables declared using the syntax
Writing a Pro*FORTRAN Program
VARCHAR Host Variables → , the dimension of the host array. VARCHAR Host Variables FORTRAN string datatypes are fixed-length … . However, Pro*FORTRAN lets you declare a variable-length string pseudotype called VARCHAR.
DBMS_LOGSTDBY, 2 of 2
Syntax → DBMS_LOGSTDBY.APPLY_SET ( parameter IN VARCHAR, value IN VARCHAR);
JMS Types, 4 of 5
Syntax → DBMS_AQJMS.GET_STRING_PROPERTY( property_name IN VARCHAR, RETURN VARCHAR);
DBMS_LOGSTDBY, 2 of 2
Syntax → DBMS_LOGSTDBY.APPLY_UNSET ( parameter IN VARCHAR);
JMS Types, 4 of 5
Syntax → DBMS_AQJMS.SET_APPID( appid IN VARCHAR);
JMS Types, 4 of 5
Syntax → DBMS_AQJMS.GET_APPID( appid OUT VARCHAR);