Index[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] [Z] Query query optimization class Query optimizer Querying data % (percent sign), wildcard [See modifying, Updating;data, search, SQL] _ (underline), wildcard [See modifying, Updating;data, search, SQL] BETWEEN predicate [See modifying, Updating;data, search, SQL] CASE expression [See modifying, Updating;data, search, SQL] case study [See modifying, Updating;data, search, SQL] CAST expression [See modifying, Updating;data, search, SQL] casting data types [See modifying, Updating;data, search, SQL] COALESCE function [See modifying, Updating;data, search, SQL] column functions [See modifying, Updating;data, search, SQL] columns combining [See modifying, Updating;data, search, SQL] derived [See modifying, Updating;data, search, SQL] intersecting values [See modifying, Updating;data, search, SQL] CTE (common table expression) [See modifying, Updating;data, search, SQL] current date and time [See modifying, Updating;data, search, SQL] EXCEPT ALL operator [See modifying, Updating;data, search, SQL] EXCEPT operator [See modifying, Updating;data, search, SQL] FETCH FIRST n ROWS ONLY clause [See modifying, Updating;data, search, SQL] FULLOUTERJOIN keyword [See modifying, Updating;data, search, SQL] GROUP BY...HAVING clause [See modifying, Updating;data, search, SQL] hierarchical data [See modifying, Updating;data, search, SQL] IN predicate [See modifying, Updating;data, search, SQL] inner joins [See modifying, Updating;data, search, SQL] INNERJOIN keyword [See modifying, Updating;data, search, SQL] INTERSECT ALL operator [See modifying, Updating;data, search, SQL] INTERSECT operator [See modifying, Updating;data, search, SQL] intersections [See modifying, Updating;data, search, SQL] isolation level [See modifying, Updating;data, search, SQL] joining tables [See modifying, Updating;data, search, SQL] LEFTOUTERJOIN keyword [See modifying, Updating;data, search, SQL] LIKE predicate [See modifying, Updating;data, search, SQL] lockout time [See modifying, Updating;data, search, SQL] NULLS [See modifying, Updating;data, search, SQL] ORDER BY clause [See modifying, Updating;data, search, SQL] OVER function [See modifying, Updating;data, search, SQL] package paths [See modifying, Updating;data, search, SQL] pattern searches [See modifying, Updating;data, search, SQL] recursive SQL [See modifying, Updating;data, search, SQL] result sets, row counts [See modifying, Updating;data, search, SQL] RIGHTOUTERJOIN keyword [See modifying, Updating;data, search, SQL] ROWNUMBER function [See modifying, Updating;data, search, SQL] rows counting in result sets [See modifying, Updating;data, search, SQL] eliminating duplicates [See modifying, Updating;data, search, SQL] grouping [See modifying, Updating;data, search, SQL] rows, retrieving adding to result sets [See modifying, Updating;data, search, SQL] between specified values [See modifying, Updating;data, search, SQL] by distinct values [See modifying, Updating;data, search, SQL] by specified values [See modifying, Updating;data, search, SQL] first n [See modifying, Updating;data, search, SQL] higher than n [See modifying, Updating;data, search, SQL] in specified order [See modifying, Updating;data, search, SQL] maximum of n [See modifying, Updating;data, search, SQL] scalar functions [See modifying, Updating;data, search, SQL] schema names [See modifying, Updating;data, search, SQL] SELECT COUNT DISTINCT statement [See modifying, Updating;data, search, SQL] SELECT COUNT statement [See modifying, Updating;data, search, SQL] SELECT DISTINCT statement [See modifying, Updating;data, search, SQL] SELECT statement examples [See modifying, Updating;data, search, SQL] selective processing [See modifying, Updating;data, search, SQL] special registers [See modifying, Updating;data, search, SQL] timestamps [See modifying, Updating;data, search, SQL] UNION operator [See modifying, Updating;data, search, SQL] UNIONALL operator [See modifying, Updating;data, search, SQL] unions [See modifying, Updating;data, search, SQL] user authorization [See modifying, Updating;data, search, SQL] WHERE clause [See modifying, Updating;data, search, SQL] Querying, load information Question mark (?), help request 2nd 3rd 4th Quiesce Quiesce points quiesce tablespaces for table command QUIESCE_CONNECT authority 2nd Quiescing table spaces |