| author | Oleksandr Gavenko <gavenkoa@gmail.com> |
| Tue, 05 Mar 2013 13:36:07 +0200 | |
| changeset 1471 | e7c7eb189a84 |
| parent 1470 | a35c9605ee53 |
| child 1472 | ca9a131b464c |
| 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 |
|
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
18 |
For ``int`` type (32-bit): ``NUMBER(9)``. |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
19 |
|
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
20 |
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
|
21 |
``SEQUENCE``. |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
22 |
|
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
23 |
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
|
24 |
Oracle Data Types |
|
e7c7eb189a84
Primary key length.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
1470
diff
changeset
|
25 |
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
|
26 |
CREATE SEQUENCE. |