| author | Oleksandr Gavenko <gavenkoa@gmail.com> |
| Thu, 03 Jan 2019 22:03:33 +0200 | |
| changeset 2332 | fc34d7c084ba |
| parent 2228 | 837f1337c59b |
| permissions | -rw-r--r-- |
|
1470
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
1 |
.. -*- coding: utf-8; -*- |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
2 |
|
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
3 |
====== |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
4 |
SQL. |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
5 |
====== |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
6 |
.. contents:: |
|
1905
fba288d59662
Include only local subsections into TOC. This prevent duplication of
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1474
diff
changeset
|
7 |
:local: |
|
1470
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
8 |
|
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
9 |
Joins. |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
10 |
====== |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
11 |
|
|
2228
837f1337c59b
Removed indentation that compiled into <blockquote>.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1912
diff
changeset
|
12 |
http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html |
|
837f1337c59b
Removed indentation that compiled into <blockquote>.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1912
diff
changeset
|
13 |
A Visual Explanation of SQL Joins. |
|
1470
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
14 |
|
|
1471
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
15 |
Primary key length. |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
16 |
=================== |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
17 |
|
|
1472
ca9a131b464c
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1471
diff
changeset
|
18 |
For ``int`` type (32-bit): ``NUMBER(9)``. For ``long`` type (64-bit): |
|
ca9a131b464c
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1471
diff
changeset
|
19 |
``NUMBER(18)``. |
|
1471
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
20 |
|
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
21 |
Oracle allow up to 38 significant digits in ``NUMBER`` and up to 28 digits in |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
22 |
``SEQUENCE``. |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
23 |
|
|
2228
837f1337c59b
Removed indentation that compiled into <blockquote>.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1912
diff
changeset
|
24 |
http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm |
|
837f1337c59b
Removed indentation that compiled into <blockquote>.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1912
diff
changeset
|
25 |
Oracle Data Types |
|
837f1337c59b
Removed indentation that compiled into <blockquote>.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1912
diff
changeset
|
26 |
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6015.htm |
|
837f1337c59b
Removed indentation that compiled into <blockquote>.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1912
diff
changeset
|
27 |
CREATE SEQUENCE. |
|
837f1337c59b
Removed indentation that compiled into <blockquote>.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1912
diff
changeset
|
28 |
http://docs.oracle.com/cd/E19501-01/819-3659/gcmaz/index.html |
|
837f1337c59b
Removed indentation that compiled into <blockquote>.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1912
diff
changeset
|
29 |
Java Type to SQL Type Mappings. |