sql.rst
changeset 1471 e7c7eb189a84
parent 1470 a35c9605ee53
child 1472 ca9a131b464c
equal deleted inserted replaced
1470:a35c9605ee53 1471:e7c7eb189a84
    10 ======
    10 ======
    11 
    11 
    12   http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
    12   http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
    13                 A Visual Explanation of SQL Joins.
    13                 A Visual Explanation of SQL Joins.
    14 
    14 
       
    15 Primary key length.
       
    16 ===================
       
    17 
       
    18 For ``int`` type (32-bit): ``NUMBER(9)``.
       
    19 
       
    20 Oracle allow up to 38 significant digits in ``NUMBER`` and up to 28 digits in
       
    21 ``SEQUENCE``.
       
    22 
       
    23   http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm
       
    24                 Oracle Data Types
       
    25   http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6015.htm
       
    26                 CREATE SEQUENCE.