Flylib.com
index_C
Previous page
Table of content
Next page
[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
Previous page
Table of content
Next page
Mastering Oracle SQL, 2nd Edition
ISBN: 0596006322
EAN: 2147483647
Year: 2003
Pages: 154
Authors:
Sanjay Mishra
,
Alan Beaulieu
BUY ON AMAZON
Introducing Microsoft Office InfoPath 2003 (Bpg-Other)
Creating Forms
Formatting Forms
Adding Views to a Template
Publishing Form Templates
Introducing InfoPath Form Template Projects
MySQL Clustering
Installation
Retrieving the Latest Snapshot from BitKeeper
Configuration
Security for MySQL Cluster
Physical Factors
The Complete Cisco VPN Configuration Guide
Packet Authentication
Address Translation and L2L Sessions
Cisco VPN Software Client
VPN Client Troubleshooting
ISAKMP/IKE Phase 1 Policies
Programming .Net Windows Applications
System Requirements
Text and Fonts
Class Hierarchy
TreeView
Getting Started with ADO.NET
FileMaker 8 Functions and Scripts Desk Reference
Exporting Data
Choose()
EvaluationError()
Developer Tools
FileMaker News Sources
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Objects, Interfaces, and Patterns
Files and Directories
ADO.NET
ASP.NET Web Applications
Remoting and Enterprise Services
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies