From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced
Join today to access over 24,800 courses taught by industry experts.
Walkthrough: Navigating the database hierarchy - Oracle Database Tutorial
From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced
Walkthrough: Navigating the database hierarchy
- [Instructor] Congratulations on getting through the Capstone. I hope you had fun with it and learned a ton. Now let's walk through how I completed it. Let's start with navigating the database hierarchy. The first challenge presented was, "What views give us information about the database?" Now, as you can see on my screen, I'm already in my SQL Plus session, so if I'm going to query the database and find out a view that will give me information about my database, it's probably going to have database in the name. (keyboard clacking) So I'm going to select view name from DBA views where view name like, (keyboard clacking) there's probably going to be a lot of them that come up here. It's a little hard to navigate. I know the V dollar views are quite helpful. Boy that changed that list, made it a lot smaller and I see the V dollar database. Notice there's an underscore in that name. We don't use this. This is the base view name underneath here and I can say, select * from v$database…
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.
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.