By Alex Kriegel; Boris M Trukhnov
Read or Download SQL bible PDF
Similar databases books
This ebook brings the entire parts of database layout jointly in one quantity, saving the reader the time and fee of creating a number of purchases. It consolidates either introductory and complicated themes, thereby overlaying the gamut of database layout method ? from ER and UML concepts, to conceptual information modeling and desk transformation, to storing XML and querying relocating items databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an program programming interface (API) that permits purposes written in С or C++ to have interaction with a number of Oracle database servers. OCI offers your courses the aptitude to accomplish the total diversity of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.
Oracle Warehouse Builder 11g: Getting Started
This easy-to-understand educational covers Oracle Warehouse Builder from the floor up, and faucets into the author's huge adventure as a software program and database engineer. Written in a calm variety with step by step motives, plenty of screenshots are supplied through the booklet. there are many information and necessary tricks all through that aren't present in the unique documentation.
Extra resources for SQL bible
Sample text
728 728 729 729 729 730 730 731 731 731 732 732 733 734 734 Appendix I: SQL-Reserved Keywords . . . . . . . .
693 Appendix G: SQL Functions . . . . . . . . . . . . 695 Appendix H: SQL Syntax Reference . . . . . . . . . . 727 DDL Statements . . . . . . Tables . . . . . . . Indexes . . . . . . Views . . . . . . . Schemas . . . . . . Stored procedures . . . User-defined functions . . Triggers . . . . . . DCL Statements . . . . . . DML Statements . . . . . . DQL Statements . . . . . . Single table select . . . Multitable SELECT .
Qxd 3/14/03 9:49 AM Page xxvii Contents Appendix B: The ACME Sample Database . . . . . . . . 613 General Information and Business Rules . . Naming Conventions . . . . . . . . Relationships Between Tables . . . . . Column Constraints and Defaults . . . .