How To Guides for Databases
  • Design
  • Tuning
  • IBM DB2
  • MySQL
  • Oracle
  • SQL Server
  • You are currently using a web browser that does not support HTML pages with style sheets. Please try the XHTML 1 or XHTML 1 Mobile version of this page instead.

    "How To" Guides for databases in general
    Database Design
    CHAR vs. VARCHAR
    Database Tuning
    Functions
    "How To" Guides for specific database management systems (DBMS)
    How To Guides for IBM DB2
    How To Guides for MySQL
    How To Guides for Oracle
    How To Guides for Microsoft SQL Server
    SQL
      DB2 MySql Oracle SQL Server
    Create Tablespace CREATE TABLESPACE
    Create Schema CREATE USER for schema
    Create User CREATE USER
    Create Role CREATE ROLE
    Create Sequence CREATE SEQUENCE
    Create Table CREATE TABLE
    Data Types
    Data Type DB2 MySql Oracle SQL Server
    Date and time (date + hh:mm:ss)
    Timestamp (date + hh:mm:ss.ff...) TIMESTAMP
    Tasks
    Task DB2 MySql Oracle SQL Server
    Backups
    Recovery RMAN

    Last updated Tuesday July 15, 2008


    Printer-friendly PDF* format:

    How To Guides for Databases

    This Section

    You are currently viewing this page in XHTML 2 Style Sheet* format (* see Clicklets for more infomation). This document is also available in HTML Style Sheet*XHTML 1* XML* HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.