December 2000
Intermediate to advanced
224 pages
9h 52m
English
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.