Teradata QueryGrid supports the following operations when Oracle is the target connector. Refer to SQL Command Reference for the Teradata Connector for information on a specific SQL syntax listed.
- Select
- Insert
- Explain
- Show/Describe
- Pass Through
QueryGrid supports predicate pushdown by default. The Oracle target connector supports the following logical WHERE conditions and expressions from Teradata systems: Abs, And, Or, Not, Gt, Lt, Le, Ge, Ln, Eq, Cast, IsNULL, Is Not NULL, Between, Concat, Extract, Lower, Upper, Like, Plus, Minus, Mult, Div, SQRT, Substring, Trim, In, and NOT IN.