skip to main
|
skip to left sidebar
skip to right sidebar
Oracle
Navigator
HOME
Select
Concat
Arithmetic
Alternative Quote
Distinct
DESC
Where
Order By
Case Manipulation
ROUND, TRUNC, MOD
Date Functions
TO_CHAR
NVL, NVL2
NULLIF, COALESCE
Decode
AVG, COUNT,SUM
MAX, MIN, STDDEV
Count
Group By
Having
Natural Join
Table Aliases
JOIN...USING
JOIN...ON
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join
Subquery
HAVING with Subqueries
Multiple Row Subqueries
Union
Union All
Intersect
Minus
Insert Into
Update
Cross Joins
•It produces the cross product of two tables
Select last_name, department_name
From employees
CROSS JOIN departments;
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Minibox 3 Column Blogger Template
by
James William
at
2600 Degrees
0 comments:
Post a Comment