| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z] calling stored functions restrictions CARDINALITY function Cartesian products 2nd CASE expression advantages divide by zero errors if-then-else functionality optional updates result sets, transforming searched selective aggregation selective function execution simple state, controlling UPDATE statement case studies, subqueries CAST function cells creating iterative models model queries references rules updating CHAR data type, TO_DATE function Character Large Object (CLOB) characters backreferences converting to dates matching 2nd named classes pattern-matching positioning child, hierarchical queries CLOB (Character Large Object) COALESCE function Codd, Dr. E. F. codes date/time formats styles collation elements, regular expressions collection types creating relationships nested tables variable arrays unnesting collections comparisons functions modifying multilevel querying unnesting columns aliases, inline views composite, GROUP BY clause concatenation conditions correlated subqueries 2nd FOR loops GROUP BY clause 2nd GROUPING SE hiding, WITH CHECK OPTION multiple-column subqueries nested group operations object-based, generating pseudocolumns CONNECT_BY_ISCYCLE CONNECT_BY_ISLEAF LEVEL range partitions repeating names, GROUP scalar functions, grouping schemas, assigning set operations (names) updating, errors USER_UPDATABLE_COLUMNS varray XML combinations, grouping comparison operators equality (=) inequality (!=) subqueries component queries composite partitioning compound queries errors NULL values concatenation columns groupings XMLForest( ) function conditional clauses conditional logic, CASE and DECODE examples conditional updates conditions CASE expressions components of early-termination equality/inequality IS PRESENT joins matching membership multiple columns pattern-matching precedence range union compatibility USING clause WHERE clause CONNECT BY clause 2nd CONNECT_BY_ISCYCLE pseudocolumn CONNECT_BY_ISLEAF pseudocolumn CONNECT_BY_ROOT operator constants, GROUP BY clause constructs, usage of containing statements correlated subqueries 2nd correspondence, GROUP BY/SELECT clauses CREATE TABLE statement, object tables CREATE TYPE BODY statement CREATE VIEW statement cross joins CUBE keyword group operations partial CUME_DIST analytic function CURRENT ROW keywords, windowing functions CURRENT_DATE function CURRENT_TIMESTAMP function customer table, SELECT statement example CV( ) function cycles identifying ignoring |