Oracle Database 11g R2: SQL Fundamentals I > Section 13: Use Data Definition Language To Create & Manage Tables - Pg. : Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Oracle Database 11g R2: SQL Fundamentals I

Oracle Database 11g R2: SQL Fundamentals I

Search

Contents

Table of Contents

Course Introduction

Section 1: About Database Technologies & Relational Databases

Section 2: Using The Database Interface

Section 3: About SQL & Building A SELECT Statement

Section 4: Restricting Data With The WHERE Clause

Section 5: Sorting Data With The ORDER BY Clause

Section 6: Pseudo Columns & Functions

Section 7: Joining Tables

Section 8: Using The Set Operators

Section 9: Summary Functions

Section 10: Using Sub-queries

Section 11: Aggregating Data Within Groups

Section 12: Build Simple SQL*Plus Reports

Section 13: Use Data Definition Language To Create & Manage Tables

Section Overview

CREATE TABLE Statement

ALTER TABLE Statement

DROP TABLE Statement

Supportive Statements

Workshop Section Use Data Definition Language To Create & Manage Tables

Section 14: Use Data Manipulation Language To Manipulate Data

Appendix A: Reference Information

URL

Help

Section 13

Use Data Definition Language To Create & Manage Tables

Objectives

Learn About SQL DDL

Use The CREATE TABLE Statement

Use The ALTER TABLE Statement

Use The DROP TABLE Statement

Use Supportive Statements

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial