From the course: Oracle Database 19c: Basic SQL
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating tables
- [Narrator] 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. First, here's an overview of database objects and how tables fit into that list of objects. An object is something owned by a schema user, aka 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. Before I demonstrate how to create a table, you'll need to know the rules for valid table names, and for the columns in the table. The rules are straightforward. Up to 128 characters long, contain letters and digits…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.