From the course: Learning Oracle Database 19c

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Create a table

Create a table - Oracle Database Tutorial

From the course: Learning Oracle Database 19c

Start my 1-month free trial Buy for my team

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