Flylib.com
index_F
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]
filters
HAVING clause
hierarchical queries, filtering
first/last queries (analytic ranking functions)
FOR loops
foreign keys
constraints, hierarchical information
relationships and
formatting dates
case-sensitivity
ISO standard
rounding and truncating considerations
fractional seconds
overview
TIMESTAMP data type
TIMESTAMP WITH LOCAL TIME ZONE data type
TIMESTAMP WITH TIME ZONE data type
free-form text, fuzziness
FROM clause, aliases
FROM_TZ function
full outer joins
old syntax
functions
ADD_MONTHS 2nd
subtracting dates
aggregate
ALL keyword
DISTINCT keyword
NULLs
aggregate analytic
FIRST_VALUE
LAST_VALUE
analytic
CUME_DIST
LAG
LEAD
NTILE
PERCENT_RANK
ranking
report partitions
reporting 2nd
WIDTH_BUCKET
windowing
built-in
pattern-matching
temporal
CARDINALITY
CAST
COALESCE
collections
CURRENT_DATE
CURRENT_TIMESTAMP
CV( )
DBTIMEZONE
DECODE
controlling state
divide by zero errors
optional updates
selective aggregation
selective function execution
syntax 2nd
transforming result sets
UPDATE statement
DENSE_RANK 2nd
deterministic
existsNode( ) member
EXTRACT
extract( ) member
extractValue( ) member
FROM_TZ
GREATEST
GROUP_ID
overview
GROUPING
ordering
GROUPING_ID
ordering
overview
hypothetical analytic
indexes
ITERATION_NUMBER
LAST_DAY 2nd
LOCALTIMESTAMP
MAX
MONTHS_BETWEEN 2nd
MULTISET EXCEPT
MULTISET INTERSECT
MULTISET UNION DISTINCT
NEW_TIME
NEXT_DAY
nonaggregate, GROUP BY Clause
NULLIF
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
syntax 2nd
NVL2, syntax 2nd
overloading
PRESENTNNV
PRESENTV
PREVIOUS
ranking analytic
DENSE_RANK
RANK
ROW_NUMBER
REGEXP
REGEXP_INSTR
REGEXP_LIKE 2nd 3rd
REGEXP_REPLACE 2nd
REGEXP_SUBSTR 2nd 3rd
regular expressions
ROUND 2nd
RTRIM, dates
SESSIONTIMEZONE
stored
avoiding table joins
calling 2nd
compared
DML statements
purity levels
rules
TRUST keyword
views
SUBSTR
SYS_CONNECT_BY_PATH
SYS_EXTRACT_UTC
SYSDATE
SYSTIMESTAMP
TO_CHAR, overview
TO_DATE 2nd 3rd
TO_DSINTERVAL
TO_YMINTERVAL
TRUNC 2nd
TZ_OFFSET
VALUE, returning objects
XMLAgg( )
XMLElement( )
XMLForest( )
fuzziness
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
Java I/O
Output Streams
PushbackInputStream
Mark and Reset
Character Sets and Unicode
Encoding Heuristics
Ruby Cookbook (Cookbooks (OReilly))
Checking to See If a File Exists
Generating PDF Files
Being a BitTorrent Client
Automatically Sending Error Messages to Your Email
Running Multiple Analysis Tools at Once
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Exaggeration Equals Characterization
Scale and Speed
Atmosphere, Film, and Noise Effects
Motion Titling Effects
Custom Scene Transitions
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Formatting Individual Shapes
Key Points
Adding Door, Window, and Furniture Shapes to Office Layouts
Creating Network Diagrams
Creating Network Reports
The Oracle Hackers Handbook: Hacking and Defending Oracle
Overview of the Oracle RDBMS
Oracle and PL/SQL
Triggers
Accessing the File System
Accessing the Network
Understanding Digital Signal Processing (2nd Edition)
THE DFT FREQUENCY RESPONSE TO A COMPLEX INPUT
FFT INPUT/OUTPUT DATA INDEX BIT REVERSAL
DESIGNING A DISCRETE HILBERT TRANSFORMER
EFFICIENTLY PERFORMING THE FFT OF REAL SEQUENCES
FREQUENCY DEMODULATION ALGORITHMS
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