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 20 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