Oracle Introduction

1. Oracle Introduction

INTRODUCTION

• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Retrieval Language (DRL)
• Transaction Control Language (TCL)
• Data Control Language (DCL)
• Alias and Merge
• FUNCTIONS
• CONSTRAINTS
• ABSTRACT DATA TYPES

DDL -- create, alter, drop, truncate, rename
DML -- insert, update, delete
DRL -- select
TCL -- commit, rollback, savepoint
DCL -- grant, revoke