From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Assignment: Navigating the database hierarchy

Assignment: Navigating the database hierarchy - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Assignment: Navigating the database hierarchy

“

- [Instructor] So we're going to start with navigating the database hierarchy. You started to get a feel for what we're going to do for this capstone, and I'm going to jump right into the questions. First question, what view gives us information about the database? Second question in this assignment is, how would we see the counter rows in a table or view? Third is, how can you select individual columns in a table or view? Fourth is how do you switch from a container database, also known as a CDB, to the pluggable database known as a PDB? Fifth question is, can you select the PDB information using the new Oracle 23c select method where is result is used in the query? And six, how would you verify that your TNS is set up for the database connection? And can you do that with a single command and not just logging into the database with SQL*Plus or SQLcl? I've got a couple hints and callouts here that hopefully will help you. Please remember, DBA views, they're your friend. Use wild card…

Contents