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 VARCHAR


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


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

Precompiler Options

VARCHARPurpose 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

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

Datatypes

VARCHARThe 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.

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

Precompiler Options

VARCHARPurpose 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

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

Datatypes and Host Variables

VARCHAR Variablesstring pseudotype called VARCHAR. A VARCHAR variable is a pseudotype that enables you to specify the

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

Datatypes and Host Variables

VARCHAR VariablesYou 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

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

Embedded PL/SQL

VARCHAR VariablesWhen entering a PL/SQL block, Oracle9 i automatically checks the length fields of VARCHAR host

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

Datatypes

LONG VARCHARThe 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.

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

Embedded PL/SQL

VARCHAR PseudotypeYou 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

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

Embedded PL/SQL

VARCHAR PseudotypeRecall 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

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

Datatypes and Host Variables

Declaring VARCHAR VariablesYou 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

Concepts, 9i Release 2 (9.2.0.2)

Native Datatypes

VARCHAR2 and VARCHAR DatatypesVARCHAR2 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

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

Advanced Topics

VARCHAR Variables and PointersThe 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

Reference Guide for Informix Dynamic Server Migrations, 9i Release 2 (9.2.0.2)

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

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

Datatypes and Host Variables

VARCHAR Variable ReferencingIn 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

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

Datatypes and Host Variables

Implicit VARCHAR Group ItemsPro*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

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

Datatypes and Host Variables

Referencing VARCHAR VariablesIn SQL statements, you reference a VARCHAR variable using the group name prefixed with a colon, as

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

Datatypes and Host Variables

VARCHAR Variable DeclarationThink 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

Concepts and Administration, 9i Release 2 (9.2.0.2)

Creating a Logical Standby Database

VARCHAR2 and VARCHARNVARCHAR2 NUMBER DATE

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

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

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Running the Oracle Precompilers

VARCHARyou want the precompiler to get needed information by connecting to Oracle and accessing the data dictionary, you must also specify USERID. VARCHAR

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

Datatypes and Host Variables

Insert NULLs Using VARCHAR VariablesIf you set the length of a VARCHAR variable to zero before performing an UPDATE or INSERT statement

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

Basic Features

Streaming CHAR, VARCHAR, or RAW ColumnsIf 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

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

Datatypes and Host Variables

Return NULLs to a VARCHAR VariableOracle 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

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

Datatypes and Host Variables

Pass VARCHAR Variables to a Functionfunctions 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);... }

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

New Features

Implicit Form of VARCHAR Group ItemsThe 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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

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

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

Datatypes and Host Variables

Find the Length of the VARCHAR Array ComponentWhen 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()

Pro*Fortran Supplement to the Oracle Precompilers Go To Documentation Library, 9i Release 2 (9.2.0.2)

Writing a Pro*FORTRAN Program

VARCHAR VariablesVARCHAR 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

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

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

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

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.

Pro*Fortran Supplement to the Oracle Precompilers Go To Documentation Library, 9i Release 2 (9.2.0.2)

Writing a Pro*FORTRAN Program

VARCHAR VariablesWhen entering a PL/SQL block, Oracle automatically checks the length fields of VARCHAR host

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

VALIDATEVALUES * VARCHAR *

Pro*Fortran Supplement to the Oracle Precompilers Go To Documentation Library, 9i Release 2 (9.2.0.2)

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

Pro*Fortran Supplement to the Oracle Precompilers Go To Documentation Library, 9i Release 2 (9.2.0.2)

Writing a Pro*FORTRAN Program

Declaring VARCHAR VariablesA VARCHAR is a set of three variables declared using the syntax

Pro*Fortran Supplement to the Oracle Precompilers Go To Documentation Library, 9i Release 2 (9.2.0.2)

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.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOGSTDBY, 2 of 2

SyntaxDBMS_LOGSTDBY.APPLY_SET ( parameter IN VARCHAR, value IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_STRING_PROPERTY( property_name IN VARCHAR, RETURN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOGSTDBY, 2 of 2

SyntaxDBMS_LOGSTDBY.APPLY_UNSET ( parameter IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_APPID( appid IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_APPID( appid OUT VARCHAR);