From the course: Learning Oracle Database 19c
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
SELECT statements: Capabilities and columns - Oracle Database Tutorial
From the course: Learning Oracle Database 19c
SELECT statements: Capabilities and columns
- [Instructor] Let's dig into some of the most common things you'll do in the database, retrieve rows and columns from your tables. To do that, you'll use the SELECT statement. At its most basic level, the SELECT statement has this structure with up to six clauses, the SELECT portion to specify what columns and expressions you want to view, the FROM clause to say what table or tables you want to get your results from, the WHERE cause to limit rows, and the GROUP BY with an optional HAVING clause to aggregate values across multiple rows. Finally, you'll use an ORDER BY to put the results in the order you want. How do you know what tables and columns you want to retrieve data from? One way is to use the old-fashioned way and query the data dictionary from SQL*Plus or SQLcl. Here I show the query against the data dictionary tab table, then the describe command to find out what's in the table. As you might suspect, there is a better way. Use SQL Developer. If you remember the initial…
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.