From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

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

Exploring database objects

Exploring database objects - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Exploring database objects

“

- [Instructor] Using SQL developer you can easily view all of the tables which have been created in the Oracle schema to which you are connected to. All you have to do is extend the tables folder under your database connection. So in our case we have an HR connection to the HR schema. Extending it we see the tables folder. Under it you see a list of all of the tables that have been created in this schema. For example, we see an employees and departments table, which we'll be using heavily throughout this course. Clicking on each one of these tables will provide us with additional information. For example, we see the table structure, the various column names that make up this table, as well as their datatypes. We learn more about datatypes later in our course. Note that in addition to the new tab that just opened with the table name we also have a row of sub tabs. For example, clicking on the data sub tab will show us the data that's currently stored in our employees table. You can…

Contents