# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1363124335 -7200
# Node ID 9299403728ff828045e71ff721a0c1b47cb86577
# Parent  ca9a131b464c0967db749df4b802a7b014648ac3# Parent  7885aaf0515686c293ae5b3907f74d24da9a09d9
merged

diff -r 7885aaf05156 -r 9299403728ff sql.rst
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sql.rst	Tue Mar 12 23:38:55 2013 +0200
@@ -0,0 +1,27 @@
+.. -*- coding: utf-8; -*-
+.. include:: HEADER.rst
+
+======
+ SQL.
+======
+.. contents::
+
+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.