sql.rst
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--
Include only local subsections into TOC. This prevent duplication of TOC when build single page HTML document. Also this make unnecessary CSS hack to hide document title as top level section.

.. -*- coding: utf-8; -*-
.. include:: HEADER.rst

======
 SQL.
======
.. contents::
   :local:

Joins.
======

  http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
                A Visual Explanation of SQL Joins.

Primary key length.
===================

For ``int`` type (32-bit): ``NUMBER(9)``. For ``long`` type (64-bit):
``NUMBER(18)``.

Oracle allow up to 38 significant digits in ``NUMBER`` and up to 28 digits in
``SEQUENCE``.

  http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm
                Oracle Data Types
  http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6015.htm
                CREATE SEQUENCE.
  http://docs.oracle.com/cd/E19501-01/819-3659/gcmaz/index.html
                Java Type to SQL Type Mappings.