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.
Data types overview
- [Lecturer] Knowing what data types, oracle database 19 C supports, and how much space they occupy, is key to being a good DBA or database designer. Disk space is never unlimited, and even if it were, using the wrong data type for one or more columns almost always has performance implications. Before I begin the deep dive into column data types, I'll do a brief review of the database objects that contain or reference columns, and the rules for naming database objects such as tables and columns. A table in a database is one of many database objects in an oracle database. An object is something owned by a schema, aka a user, and can be created and manipulated by SQL statements. Here are the uttemost common data types of database objects you'll use on a regular basis: tables, indexes, views, synonyms, and so forth. I mentioned these other database objects because they all come back to where your data is stored, in table columns. Here are the rules for valid column names and for the…
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.