After writing and executing a SQL query using SQL Developer, the results of the query obtained from the database can be presented to us in either a grid or script view. In this video, view the output of a query.
- [Instructor] Note that once you write…and execute SQL queries throughout this course…using Oracle SQL Developer,…the output or result set of the SQL query…will be displayed in the bottom pane of your screen…under the query results tab.…In addition to providing…the actual query results themselves,…which will include the column names…as well as the actual records,…you will also see how many rows…have been retrieved from the database…and how long it took to retrieve those rows.…
Remember that what you see on the screen right now…is a partial result.…And you can scroll down to see a complete result…of all of the records that were retrieved…as part of your SQL query.…Also note that some columns…especially for very wide tables…that contain a lot of columns might be hidden.…And you will have to scroll to the right to see them.…Also note that you can refresh the output…by clicking on the refresh button.…And clicking on the SQL button will give you the SQL command…that was used to display the output that you see…in the bottom grid…
Note: This training course is appropriate for beginning database developers with no prior experience with SQL or Oracle.
- Using Oracle SQL*Developer, the free development environment
- Selecting data from tables
- Filtering data
- Using functions to manipulate data
- Joining data from tables
- Creating tables
- Updating values
- Truncating data
- Grouping and ordering result sets
- Working with primary keys
- Checking constraints
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
1. Introduction to SQL
2. Preparing the Course Environment
Downloading the course VM2m 16s
3. Using Oracle SQL Developer
4. Basic SELECT Queries
5. String, Number, and Date Functions
6. Joining Table Data
7. Manipulating Data
8. Grouping Data
9. Advanced Topics
Next steps1m 33s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.