sql.rst
author Oleksandr Gavenko <gavenkoa@gmail.com>
Mon, 09 Oct 2017 10:49:36 +0300
changeset 2188 e95731eef030
parent 1912 8b81a8f0f692
child 2228 837f1337c59b
permissions -rw-r--r--
Fixed: NameError: name 'locale_encoding' is not defined File /bin/rst2html.py, line 17, in <module> from docutils.core import publish_cmdline, default_description File /usr/lib/python2.7/site-packages/docutils/core.py, line 20, in <module> from docutils import frontend, io, utils, readers, writers File /usr/lib/python2.7/site-packages/docutils/frontend.py, line 41, in <module> import docutils.utils File /usr/lib/python2.7/site-packages/docutils/utils/__init__.py, line 20, in <module> import docutils.io File /usr/lib/python2.7/site-packages/docutils/io.py, line 18, in <module> from docutils.utils.error_reporting import locale_encoding, ErrorString, ErrorOutput File /usr/lib/python2.7/site-packages/docutils/utils/error_reporting.py, line 60, in <module> codecs.lookup(locale_encoding or '') # None -> '' NameError: name 'locale_encoding' is not defined
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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
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.