author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Mon, 19 Oct 2015 17:04:52 +0300 | |
changeset 1769 | cadd23f8127f |
parent 1474 | e461c2e7d620 |
child 1905 | fba288d59662 |
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:: |
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 |
|
a35c9605ee53
A Visual Explanation of SQL Joins.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
12 |
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
|
13 |
A Visual Explanation of SQL Joins. |
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 |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
24 |
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
|
25 |
Oracle Data Types |
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
26 |
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
|
27 |
CREATE SEQUENCE. |
1474
e461c2e7d620
Java Type to SQL Type Mappings.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1472
diff
changeset
|
28 |
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
|
29 |
Java Type to SQL Type Mappings. |