Example Queries on the rmvTable

To use Oracle Big Data SQL to query data in the Oracle NoSQL Database rmvTable, you can similarly execute basic queries like the following on the Oracle Database external table you mapped to that table in the Oracle NoSQL Database store. For example,

SELECT * FROM rmvTable;

SELECT lastname,firstname,gender,address FROM rmvTable;

SELECT min(ssn) FROM rmvTable;

SELECT count(*) FROM rmvTable;

SELECT firstname,lastname,phoneinfo FROM rmvTable;

SELECT vehicleinfo FROM rmvTable;