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 SMALLINT


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


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

Oracle and Informix Dynamic Server Compared

SMALLINTThe Informix Dynamic Server SMALLINT datatype is mapped to NUMBER(5). Range Boundaries The Informix … columns are within the range -32,767 to 32767. Storage Informix Dynamic Server SMALLINT datatype

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

SIZE *SMALLINT *

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

Fundamentals of PL/SQL

Restrictions on Declarations… PL/SQL does not allow this. For example, the following declaration is not allowed: i, j, k SMALLINT … ; -- not allowed You must declare each variable separately: i SMALLINT; j SMALLINT; k SMALLINT;

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

PL/SQL Collections and Records

Initializing RecordsRECORD ( secs SMALLINT:= 0, mins SMALLINT:= 0, hrs SMALLINT:= 0); BEGIN... END; The next example

Heterogeneous Connectivity Administrator's Guide, 9i Release 2 (9.2.0.2)

Data Type Mapping

Mapping ANSI Data Types to Oracle Data Types Through an OLE DB InterfaceOracle NUMERIC(3,0) DBTYPE_UI1 NUMBER(3) NUMERIC(3,0) DBTYPE_I1 NUMBER(3) SMALLINT DBTYPE_UI2 NUMBER(5 … ) SMALLINT DBTYPE_I2 NUMBER(5) NUMERIC(3,0) DBTYPE_BOOL NUMBER(5) INTEGER DBTYPE_UI4 NUMBER(10

SQL*Module for Ada Programmer's Guide, 9i Release 2 (9.2.0.2)

Demonstration Programs

Module Language Sample ProgramSMALLINT,:id INTEGER,:status CHAR(5),:major INTEGER,:major_ind SMALLINT, -- indicator for major … :adv INTEGER,:adv_ind SMALLINT, -- indicator for advisor SQLCODE); FETCH get_students_curs INTO:lname … add_student (:last_name CHARACTER(15),:first_name CHARACTER(15),:mi CHARACTER(3),:mi_ind SMALLINT,:sid … INTEGER,:status

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

PL/SQL Collections and Records

Defining and Declaring Records… DECLARE TYPE TimeRec IS RECORD ( seconds SMALLINT, minutes SMALLINT, hours SMALLINT); TYPE FlightRec IS

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

JPublisher Concepts

Allowed Object Attribute TypesPRECISION, FLOAT INTEGER, SMALLINT, INT REAL RAW, LONG RAW CLOB BLOB BFILE NCLOB object type, OPAQUE

Utilities, 9i Release 2 (9.2.0.2)

Field List Reference

Examples of Using POSITIONsiteid POSITION (*) SMALLINT siteloc POSITION (*) INTEGER If these were the first two column

SQL*Module for Ada Programmer's Guide, 9i Release 2 (9.2.0.2)

Module Language

SQL Datatypes  SMALLINT  exact numeric, no fractional part, equal to or smaller in range than INTEGER  Oracle Datatype … DOUBLE PRECISION ARRAY(N) OF INTEGER ARRAY(N) OF REAL ARRAY(N) OF SMALLINT ARRAY(N) OF VARCHAR2(L

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting a Datatype

ANSI/ISO, DB2, and SQL/DS Datatypes), DECIMAL (p,s), DEC (p,s) NUMBER (p,s) INTEGER, INT, SMALLINT NUMBER (38) FLOAT (p) FLOAT (p) REAL … (n) LONG VARCHAR LONG DECIMAL (p,s) NUMBER (p,s) INTEGER, SMALLINT NUMBER (38) FLOAT (p) FLOAT (p) DATE DATE TIMESTAMP TIMESTAMP

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

Fundamentals of PL/SQL

Declarationscouple of examples follow: birthday DATE; emp_count SMALLINT:= 0; The first declaration names a variable … of type DATE. The second declaration names a variable of type SMALLINT and uses the assignment

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

PL/SQL Packages

Understanding The Package SpecPACKAGE trans_data AS -- bodiless package TYPE TimeRec IS RECORD ( minutes SMALLINT, hours SMALLINT

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

PL/SQL Language Elements, 39 of 52

Usage Notesexample shows: DECLARE TYPE TimeTyp IS RECORD( seconds SMALLINT:= 0, minutes SMALLINT:= 0, hours … SMALLINT:= 0); The next example shows that you can use the %TYPE attribute to specify the datatype of a … ( minutes SMALLINT, hours SMALLINT); TYPE MeetingTyp IS RECORD( day DATE, time_of TimeTyp, -- nested

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

Datatypes

Typecodes: CREATE TYPE my_type AS OBJECT ( attr1 NUMBER, attr2 INTEGER, attr3 SMALLINT); CREATE TABLE my_table AS … , my_table will have three columns, all of which are of Oracle NUMBER type, because SMALLINT and INTEGER … OCI_TYPECODE_OCTET octet OCI_TYPECODE_INTEGER integer OCI_TYPECODE_SMALLINT smallint OCI_TYPECODE_RAW RAW

SQL*Module for Ada Programmer's Guide, 9i Release 2 (9.2.0.2)

Module Language

Indicator Parameterslist, an indicator parameter always has a SMALLINT type. In the SQL statement, the indicator parameter … SMALLINT,:class_number INTEGER,:student_id INTEGER, SQLCODE); SELECT grade INTO:grade INDICATOR … ),:commission REAL,:comm_ind SMALLINT, SQLCODE); UPDATE emp SET comm =:commission INDICATOR:comm_ind WHERE

SQL*Module for Ada Programmer's Guide, 9i Release 2 (9.2.0.2)

Developing the Ada Application

Indicator Variables(:commission REAL,:comm_ind SMALLINT,:emp_number INTEGER, SQLSTATE); SELECT comm INTO:commission … ,:bin_no_ind SMALLINT, SQLSTATE); INSERT INTO inventory (part_number, description, bin_no) VALUES (:part_no

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

PL/SQL Collections and Records

Referencing RecordsTimeRec IS RECORD (minutes SMALLINT, hours SMALLINT); TYPE AgendaItem IS RECORD ( priority INTEGER

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

Reference Information

Supported SQL and PL/SQL DatatypesNATIONAL CHAR VARYING no no NCHAR yes yes NCHAR VARYING no no NUMERIC yes yes REAL yes yes SMALLINT … yes POSITIVE yes yes POSITIVE n no no REAL yes yes SIGNTYPE yes yes SMALLINT yes yes Scalar Character … BINARY INTEGER. The types DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NUMERIC, REAL, and SMALLINT are subtypes of NUMBER.

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

PL/SQL Collections and Records

Assigning Recordsdifferent datatypes. DECLARE TYPE TimeRec IS RECORD (mins SMALLINT, hrs SMALLINT); TYPE MeetingRec IS