From the course: SQL Queries Made Easy
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Database table types - SQL Tutorial
From the course: SQL Queries Made Easy
Database table types
- [Instructor] In this video, we will learn about the two kinds of tables in Oracle database. They are user-defined tables, or user tables, and data dictionary tables. User-defined tables are a collection of tables created and maintained by the users, unlike data dictionary tables, which are a collection of tables created and maintained by the Oracle server. User tables will contain information about the users, while data dictionary tables will contain database information. User tables are owned by different users, while data dictionary tables are owned by SYS user. Now, let's learn a little more in detail about data dictionary tables. These tables contain information about Oracle server users, privileges granted to the users, table constraints and more details about various database objects. Some of the most frequently used data dictionary tables are USER_TABLES, which is used to find out the tables that we own. The…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.