Chapter 2. SQL*Plus and iSQL*Plus Basics
This chapter begins with a few formalities and definitions and then dives right into a discussion of the different ways to run SQL commands. Then it introduces the basics of SELECT statements and how we can retrieve and display either all columns or only certain columns of a table.
You will also find out about how to make changes to the rows in a table by using INSERT, UPDATE, MERGE, and DELETE statements. In the remainder of the chapter, you will explore various ways to change the structure of tables in the database as well as control the permissions on tables.
Get Oracle Database Foundations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
