
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
Database Gateway for Teradata User's Guide - Contents
Contents → Database 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
Supported SQL Syntax and Functions
Oracle Teradata → B.2.2.4 String Functions Oracle Teradata INSTR POSITION
Supported SQL Syntax and Functions
Oracle Teradata → B.2.2.2 Comparison Operators Oracle Teradata = = > > = >=, !=, ^= <>, != IS NOT NULL IS NOT NULL IS NULL IS NULL
Supported SQL Syntax and Functions
Oracle Teradata → B.2.2.3 Group Functions Oracle Teradata AVG AVG COUNT COUNT MAX MAX MIN MIN SUM SUM
Supported SQL Syntax and Functions
Oracle Teradata → B.2.2.5 Other Functions Oracle Teradata ABS ABS EXP EXP LOG(a, b) LOG10(b) / LOG10(a) POWER ** SQRT SQRT
Supported SQL Syntax and Functions
Oracle Teradata → B.2.2.1 Arithmetic Operators Oracle Teradata + + - - * * / /
Data Type Conversion
Teradata Oracle Comment → BLOB 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,
Configuring Oracle Database Gateway for Teradata
7.7.5 Multiple Teradata Databases Example: Accessing Teradata Data → created, you can verify the connection to the new Teradata databases, as in the following: SQL
Configuring Oracle Database Gateway for Teradata
7.7.5 Multiple Teradata Databases Example: Accessing Teradata Data → created, you can verify the connection to the new Teradata databases, as in the following: SQL
Installing Oracle Database Gateway for Teradata
6 Installing Oracle Database Gateway for Teradata → procedure 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
Supported SQL Syntax and Functions
B.2.2 Functions Supported by Teradata → equivalent Teradata functions: Arithmetic Operators Comparison Operators Group Functions String Functions Other Functions
Teradata Gateway Features and Restrictions
2 Teradata Gateway Features and Restrictions → After 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
Teradata Gateway Features and Restrictions
2.9.1 Teradata LONG VARCHAR Data Type → cannot 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
Configuring Oracle Database Gateway for Teradata
7 Configuring Oracle Database Gateway for Teradata → Teradata: 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
Installing Oracle Database Gateway for Teradata
6 Installing Oracle Database Gateway for Teradata → procedure 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.
Case Studies
3.8 Case 3: Joining Teradata Tables → Case 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
Data Dictionary
C.1.3 Direct Queries to Teradata Tables → Queries 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.
Data Dictionary
View Name Teradata System Table Name → ALL_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
Configuring Oracle Database Gateway for Teradata
7 Configuring Oracle Database Gateway for Teradata → Teradata: 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
Teradata Gateway Features and Restrictions
2.7 Database Compatibility Issues for Teradata → Teradata and Oracle databases function differently in some areas, causing compatibility problems