| author | Oleksandr Gavenko <gavenkoa@gmail.com> |
| Mon, 22 Feb 2016 12:46:36 +0200 | |
| changeset 1905 | fba288d59662 |
| parent 1474 | e461c2e7d620 |
| child 1912 | 8b81a8f0f692 |
| 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 |
.. include:: HEADER.rst |
|
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 |
====== |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
5 |
SQL. |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
6 |
====== |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
7 |
.. contents:: |
|
1905
fba288d59662
Include only local subsections into TOC. This prevent duplication of
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1474
diff
changeset
|
8 |
:local: |
|
1470
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
9 |
|
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
10 |
Joins. |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
11 |
====== |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
12 |
|
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
13 |
http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
14 |
A Visual Explanation of SQL Joins. |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
15 |
|
|
1471
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
16 |
Primary key length. |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
17 |
=================== |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
18 |
|
|
1472
ca9a131b464c
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1471
diff
changeset
|
19 |
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
|
20 |
``NUMBER(18)``. |
|
1471
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
21 |
|
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
22 |
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
|
23 |
``SEQUENCE``. |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
24 |
|
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
25 |
http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
26 |
Oracle Data Types |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
27 |
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6015.htm |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
28 |
CREATE SEQUENCE. |
|
1474
e461c2e7d620
Java Type to SQL Type Mappings.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1472
diff
changeset
|
29 |
http://docs.oracle.com/cd/E19501-01/819-3659/gcmaz/index.html |
|
e461c2e7d620
Java Type to SQL Type Mappings.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1472
diff
changeset
|
30 |
Java Type to SQL Type Mappings. |