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
Interprocess Communications in Linux: The Nooks and Crannies
File System Information
More About Signals
A ClientServer Message Queue Example
Encoding and Decoding Arbitrary Data Types
D.2. Sample Program for Profiling
Inside Network Security Assessment: Guarding Your IT Infrastructure
Four Ways in Which You Can Respond to Risk
The Policy Framework
Why Risk Assessment
Risk-Assessment Terminology
A Brief History of Security Tools
Strategies for Information Technology Governance
An Emerging Strategy for E-Business IT Governance
Measuring and Managing E-Business Initiatives Through the Balanced Scorecard
A View on Knowledge Management: Utilizing a Balanced Scorecard Methodology for Analyzing Knowledge Metrics
Measuring ROI in E-Commerce Applications: Analysis to Action
Governance Structures for IT in the Health Care Industry
MySQL Cookbook
Writing Strings That Include Quotes or Special Characters
Treating Dates or Times as Numbers
Finding Smallest or Largest Summary Values
Converting Datafiles from One Format to Another
Extending the Range of a Sequence Column
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The Pulsing Heart of ASP.NET AJAX
Partial Page Rendering
The AJAX Control Toolkit
Built-in Application Services
Building AJAX Applications with ASP.NET
Python Programming for the Absolute Beginner, 3rd Edition
The os.path to Knowledge
Time Tools, Threads, and Animation
A Simple Python File Server
The PyMailCgi Web Site
Sorting Sequences
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