Flylib.com
index_P
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]
packages
body
specification
stored procedures and functions
parameters
databases
match_parameter
object types
parentheses [( )]
operator/condition precedence
subqueries
parents
hierarchical queries
root nodes, finding
parsing, avoiding unnecessary
partial CUBE queries
partial matches (IN operator)
partial ROLLUP queries
PARTITION BY clause
analytic ranking functions
PARTITION clause
partition outer joins 2nd
partitions
composite
hash
horizontal
indexes
key
hash partitioning
optimizer and
list
methods
naming considerations
performance
pruning
range
specifying
storage considerations
tables, overview
vertical
views
paths
nodes, finding
notation elements
pattern-matching
built-in functions
conditions
patterns
anti-patterns, finding
occurrence of
percent sign (%), pattern-matching character
PERCENT_RANK analytic function
performance
partitioning and
selective function exec 2nd
Perl, regular expression usage
phantom columns
pivot tables, creating dates
PL/SQL
CASE expressions and
date pivot tables
deterministic functions
DML statements, stored functions in
including SQL
overview
restrictions on calling
stored functions
avoiding table joins
calling from queries
views
stored functions compared to stored procedures
variables, converting to DATE data type
placement of join conditions
PM indicator (time format)
populating data, XML
POS (positive) transition types
positional cell references
positioning characters
positive (POS) transition types
pragmas, adding
precedence
operator/condition
set operators
PRESENTNNV function
PRESENTV function
PREVIOUS function
primary keys, comparing tables
printing numeric amounts
PRIOR operator, hierarchical queries
programming languages, nonprocedural
programming, style issues
properties, key-preserved tables
pruning partitions
pseudocolumns
CONNECT_BY_ISCYCLE
CONNECT_BY_ISLEAF
LEVEL
ROWID
purch_ord.xsd file
purity levels
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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Writing Database-Independent Code
Searching and Analyzing Data
Using Expression Columns to Display Calculated Values
Creating a Class That Participates in an Automatic Transaction
A.6. Delegates
The .NET Developers Guide to Directory Services Programming
LDAP Basics
Returning Many Results with Paged Searches
ADSI Schema Mapping Mechanism
Choosing Attribute Syntaxes
Managing User Account Features
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter One Solutions
Chapter Two Principles
Chapter Seven Diagnose Before You Prescribe
Chapter Nine Selling When You re Not First
Chapter Fifteen Sales Management System: Managers Managing Pipelines and Salespeople
Special Edition Using Crystal Reports 10
Using Existing Crystal Reports as Templates
Troubleshooting
Crystal Enterprise Architecture
The Client Tier
Troubleshooting
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
Computers as Persuasive Media Simulation
Computers as Persuasive Social Actors
Credibility and the World Wide Web
The Ethics of Persuasive Technology
Captology Looking Forward
Microsoft VBScript Professional Projects
Scheduling Disk Maintenance
Collecting Remote Summary Reports
Archive Management
Report Distribution and Remote Archive Management
Appendix B Whats on the Companion Web Site
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