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 Teradata


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


Database Gateway for Teradata User's Guide

Database Gateway for Teradata User's Guide - Contents

ContentsDatabase Gateways 2 Teradata Gateway Features and Restrictions 2.1 Using the Pass-Through Feature … Compatibility Issues for Teradata 2.7.1 Schema Considerations 2.7.2 Naming Rules 2.7.2.1 Rules for Naming … links 2.9 Known Problems 2.9.1 Teradata LONG VARCHAR Data Type 2.9.2 Schema Names and PL/SQL 2.9.3 Data … More Complex Query

Database Gateway for Teradata User's Guide

Supported SQL Syntax and Functions

Oracle TeradataB.2.2.5 Other Functions Oracle Teradata ABS ABS EXP EXP LOG(a, b) LOG10(b) / LOG10(a) POWER ** SQRT SQRT

Database Gateway for Teradata User's Guide

Supported SQL Syntax and Functions

Oracle TeradataB.2.2.3 Group Functions Oracle Teradata AVG AVG COUNT COUNT MAX MAX MIN MIN SUM SUM

Database Gateway for Teradata User's Guide

Supported SQL Syntax and Functions

Oracle TeradataB.2.2.4 String Functions Oracle Teradata INSTR POSITION

Database Gateway for Teradata User's Guide

Supported SQL Syntax and Functions

Oracle TeradataB.2.2.1 Arithmetic Operators Oracle Teradata + + - - * * / /

Database Gateway for Teradata User's Guide

Supported SQL Syntax and Functions

Oracle TeradataB.2.2.2 Comparison Operators Oracle Teradata = = > > = >=, !=, ^= <>, != IS NOT NULL IS NOT NULL IS NULL IS NULL

Database Gateway for Teradata User's Guide

Data Type Conversion

Teradata Oracle CommentBLOB LONG RAW   BYTE RAW - BYTEINT NUMBER(3) BYTEINT range is -128 to +127 CHAR CHAR - CHAR CHARACTER SET UNICODE CHAR - CLOB LONG   DATE CHAR(10) - DECIMAL NUMBER(p[,s]) - FLOAT FLOAT(24) with precision single precision float INTEGER NUMBER(10) NUMBER range is -2,147,483,648 to 2,147,483,647 INTERVAL CHAR - LONG VARCHAR CHARACTER SET UNICODE LONG if Oracle DB Character Set = Unicode. Otherwise,

Database Gateway Installation and Configuration Guide for Microsoft Windows

Configuring Oracle Database Gateway for Teradata

7.7.5 Multiple Teradata Databases Example: Accessing Teradata Datacreated, you can verify the connection to the new Teradata databases, as in the following: SQL

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64

Configuring Oracle Database Gateway for Teradata

7.7.5 Multiple Teradata Databases Example: Accessing Teradata Datacreated, you can verify the connection to the new Teradata databases, as in the following: SQL

Database Gateway for Teradata User's Guide

Teradata Gateway Features and Restrictions

2 Teradata Gateway Features and RestrictionsAfter the gateway is installed and configured, you can use the gateway to access Teradata data … , pass Teradata commands from applications to the Teradata database, perform distributed queries, and … Gateway Session IDLE Timeout Database Compatibility Issues for Teradata Known Restrictions Known Problems

Database Gateway Installation and Configuration Guide for Microsoft Windows

Installing Oracle Database Gateway for Teradata

6 Installing Oracle Database Gateway for Teradataprocedure for Oracle Database Gateway for Teradata. To install the gateway, follow these steps … Requirements for Oracle Database Gateway for Teradata\" section. Run the Oracle Universal Installer See … which they appear depend on your platform. See Table 6-2 for a description of the installation procedure of Oracle Database Gateway for Teradata.

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64

Installing Oracle Database Gateway for Teradata

6 Installing Oracle Database Gateway for Teradataprocedure for Oracle Database Gateway for Teradata. To install the gateway, follow these steps … Requirements for Oracle Database Gateway for Teradata\". Run the Oracle Universal Installer. See \"Step … appear depend on your platform. See Table 6-3 for a description of the installation procedure of Oracle Database Gateway for Teradata

Database Gateway for Teradata User's Guide

Data Dictionary

C.1.3 Direct Queries to Teradata TablesQueries issued directly to individual Teradata system catalog tables are allowed but they return … different results because the Teradata system catalog table column names differ from those of the data … dictionary view. Also, certain columns in a Teradata system catalog table cannot be used in data dictionary processing.

Database Gateway for Teradata User's Guide

Case Studies

3.8 Case 3: Joining Teradata TablesCase 3 demonstrates the following: Joins between Teradata tables. Subselects. The query retrieves … information from three Teradata tables and relates the employees to their department name and salary

Database Gateway for Teradata User's Guide

Supported SQL Syntax and Functions

B.2.1 Functions Not Supported by TeradataOracle SQL functions with no equivalent function in Teradata are not supported in DELETE, INSERT

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64

Configuring Oracle Database Gateway for Teradata

7 Configuring Oracle Database Gateway for TeradataTeradata: Configure the Gateway Initialization Parameter File Configure Oracle Net for the Gateway … Encrypt Gateway Initialization Parameter Values Configure the Gateway to Access Multiple Teradata Databases

Database Gateway for Teradata User's Guide

Teradata Gateway Features and Restrictions

2.7 Database Compatibility Issues for TeradataTeradata and Oracle databases function differently in some areas, causing compatibility problems

Database Gateway for Teradata User's Guide

Teradata Gateway Features and Restrictions

2.9.1 Teradata LONG VARCHAR Data Typecannot be used in a SQL statement that accesses a column defined as Teradata data type LONG VARCHAR … . You cannot use SQL*Plus to select data from a column defined as Teradata data type LONG VARCHAR when … Interface to access such data in a Teradata database. LONG VARCHAR data types must be NULLABLE for INSERT

Database Gateway for Teradata User's Guide

Data Dictionary

C.1.1 Teradata System Catalog TablesTeradata data dictionary information is stored in the Teradata database as Teradata system catalog … tables. The Teradata system catalog tables define the structure of a database. When you change data … definitions, Teradata reads and modifies the Teradata system catalog tables to add

Database Gateway for Teradata User's Guide

Data Dictionary

View Name Teradata System Table NameALL_CATALOG DBC.TablesX + DBC.IndicesX ALL_COL_COMMENTS DBC.ColumnsX ALL_CONS_COLUMNS DBC.Indices ALL_CONSTRAINTS DBC.IndicesX ALL_IND_COLUMNS DBC.Indices + DBC.Tables + DBC.Columns ALL_INDEXES DBC.Indices ALL_OBJECTS DBC.IndicesX + DBC.TablesX ALL_TAB_COLUMNS DBC.ColumnsX + DBC.TablesX ALL_TAB_COMMENTS DBC.Tables ALL_TABLES DBC.TablesX ALL_USERS DBC.Databases ALL_VIEWS DBC.Tables DBA_CATALOG DBC.Tables