'Column datatype' presentation slideshows

Lecture 1: SQL: DDL & DML

Lecture 1: SQL: DDL & DML. DCO11310 Database Systems and Design By Rose Chang. Outline of Lecture. SQL and its Origins Overview of Oracle 9i & iSQL*Plus Writing DML & DDL Write a SELECT statement that: Returns all rows and columns from a table Returns specified columns from a table

1.64k views • 71 slides

Creating and Managing Tables

Creating and Managing Tables. Objectives. At the end of this lesson, you will be able to: Describe the main database objects Create tables Describe the datatypes that can be used when specifying column definition Alter table definitions Drop, rename, and truncate tables. Database Objects.

328 views • 22 slides

ORACLE SQL

453 views • 19 slides

ORACLE SQL

322 views • 19 slides

ORACLE SQL

425 views • 19 slides

Creating and Managing Tables

Creating and Managing Tables. Objectives. After completing this lesson, you should be able to do the following: Describe the main database objects Create tables Describe the data types that can be used when specifying column definition Alter table definitions

277 views • 16 slides