Conclusion
The breadth and scope of the SQL commands provide the capability to
create and manipulate a wide variety of database objects using the
various CREATE
, ALTER
, and
DROP
commands. Those database objects then can
be loaded with data using commands such as
INSERT
. The data can be manipulated using a wide
variety of commands, such as SELECT
,
DELETE
, and TRUNCATE
, as
well as the cursor commands, DECLARE
,
OPEN
, FETCH
, and
CLOSE
. Transactions to manipulate the data are
controlled through the SET
command, plus the
COMMIT
and ROLLBACK
commands. And finally, other commands covered in this chapter include
those that control a user’s access to database resources
through commands such as GRANT
and
REVOKE
.
Get SQL in a Nutshell 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.