Select - Teradata QueryGrid

Teradata® QueryGrid™ インストールとユーザー ガイド

Product
Teradata QueryGrid
Release Number
2.11
Published
2019年12月
Language
日本語
Last Update
2020-04-13
dita:mapPath
ja-JP/fya1571089961130.ditamap
dita:ditavalPath
ft:empty
dita:id
lfq1484661135852
次の例では、Teradataシステム上でOracleターゲット コネクタによってサポートされているさまざまなSELECTコマンドを使用します。

Select

SELECT CAST(Price AS DECIMAL (8,2))
       , mileage
       , CAST(make AS VARCHAR(20))
       , CAST(model AS VARCHAR(20))
FROM cardata@oraclefs_active WHERE make=’Buick’;
       price     mileage  make    model
       --------  -------  ------  --------------------
       17314.10  8221     Buick   Century
       17542.04  9135     Buick   Enclave

Foreign TableでSelect

SELECT * FROM FOREIGN TABLE (SELECT make, model FROM default.cardata where make = 'Buick')@oraclefs_active AS dt;
make    model
------  --------------------
Buick   Century
Buick   Enclave

Export句でSelect

    SELECT * from FOREIGN TABLE(select * from tmpabc )@oraclefs_active EXPORT((select * from oracleTypet) AS tmpabc) as dt;


     *** Query completed. One row found. 11 columns returned.
     *** Total elapsed time was 15 seconds.

     c1                   c2
     -------------------- ---------------------------------------- -------------
     abc                  aaaaxxxxxx

Returns句でSelect

SELECT * FROM datatypes1@oraclefs_active RETURNS (varchar1 VARCHAR(5) CHARACTER SET LATIN) WHERE bigint1 > 10000 AND double1 < 10000;