O'Reilly logo

Oracle PL/SQL in 10 Minutes, Sams Teach Yourself by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Lesson 20. Creating and Manipulating Tables

In this lesson, you’ll learn the basics of table creation, alteration, and deletion.

Creating Tables

Oracle PL/SQL statements are not used just for table data manipulation. Indeed, SQL statements can be used to perform all database and table operations, including the creation and manipulation of tables themselves.

There are generally two ways to create database tables:

Image Using a database client (like the ones discussed in Lesson 2, “Getting Started with Oracle and PL/SQL”) that can be used to create and manage database tables interactively

Manipulating tables directly with Oracle PL/SQL statements

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required