From the course: Introduction to Oracle SQL (26ai)

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Run basic Oracle SQL commands, part two

Run basic Oracle SQL commands, part two - Oracle Database Tutorial

From the course: Introduction to Oracle SQL (26ai)

Start my 1-month free trial Buy for my team

Run basic Oracle SQL commands, part two

“

- Welcome. In the next couple minutes, we'll dive into part two of basic Oracle SQL Commands. You'll learn how to make data retrieval faster, update and aggregate data, and alter the structure of your tables as needed, and in case something goes wrong, we'll also explore how to delete, drop, and even undo the dropping of a table. Let's go. The data dictionary is a special set of tables that store metadata about your database. You can query it to get information about your tables, columns and more. This query tells us where the employee's table is stored and its status. You can use the data dictionary to check for any changes or issues. To update data, we use the update statement. You can change specific rows or all rows in a table. The first query updates all employee records to set the country_code to US. The second updates only Sam Smith's commission. SQL supports aggregate functions like count, sum, minimum, and maximum to…

Contents