Learning Visually with Examples [Electronic resources] نسخه متنی

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