vehicleTableに対する問合せの例

Oracle Big Data SQLを使用してOracle NoSQL Database vehicleTableのデータを問い合せる場合は、SQL SELECTコマンドを使用して、その表にマップしたOracle外部表を問い合せます。次に例を示します。

col type format A5;
col make format A8;
col model format A15;
col class format A25;
col color format A16;
col price format $99,999.90;
col count format 99999;
col dealerid format 0.999999999999999999999999999999999999990;
col delivered format A30; 

set linesize 500;

SELECT * FROM vehicleTable; 
SELECT count(*) FROM vehicleTable;
SELECT min(price) FROM vehicleTable; 
SELECT min(dealerid) FROM vehicleTable; 

SELECT * FROM vehicleTable WHERE make='GM'; 
SELECT * FROM vehicleTable WHERE model='Camaro'; 
SELECT * FROM vehicleTable WHERE model LIKE '%Silverado%'; 
SELECT * FROM vehicleTable WHERE color='yellow' 
    AND type > 'auto' AND type < 'truck'; 
SELECT * FROM vehicleTable WHERE 
    type > 'auto' AND type <= 'truck' AND make LIKE 'Ford';
SELECT * FROM vehicleTable WHERE dealerid > 0.7 AND dealerid < 0.75;
SELECT * FROM vehicleTable WHERE delivered 
    BETWEEN '06-JUN-12 06:53:41.448643 AM' AND '05-SEP-15 03:40:22.057282 PM' 
    ORDER BY delivered;

Oracle NoSQL Databaseストアがセキュア・ストアである場合にOracle Database外部表vehicleTablePasswdまたはvehicleTableWallet (あるいはその両方)を作成した場合は、前述の問合せの名前vehicleTableをvehicletablePasswdまたはvehicleTableWallet (あるいはその両方)に置き換えます。