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:
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
Get Oracle PL/SQL in 10 Minutes, Sams Teach Yourself now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.