From the course: Learning Oracle Database 19c

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a table

Create a table - Oracle Database Tutorial

From the course: Learning Oracle Database 19c

Start my 1-month free trial

Create a table

“

- [Instructor] Whether your role is a developer, DBA, or report writer, at some point you'll want to create a new table, either for temporary or permanent use. In this video, I'll tell you how tables fit in with the other database object types, what data types are supported in an Oracle database 19c table, and how to constrain column values. A table in a database is one of many database objects in an Oracle database. An object is something owned by a schema, also known as a user, and can be created and manipulated by SQL statements. Here are the most common types of database objects you'll use on a regular basis, tables, indexes, views, synonyms, and so forth. I mention these other database objects because they all come back to where your data is stored, in a table. As a reminder, here are the rules for valid table names and column names in a table. The same as for most database objects, the rules are straightforward. Up to 128 characters long, contains letters and digits as well as…

Contents