Appendix E

Important Commands and Functions

ACCEPT SQLPLUS command that takes input from a keyboard and puts it in a named variable. It is used within a script.

ALTER TABLE SQL command that allows a user to add columns to, or modify columns in a table.

ALTER TRIGGER SQL command that allows a user to modify a trigger.

APPEND SQLPLUS command that allows a user to add text to the end of the current line without using an editor. This is a command line function.

AVG SQL function that averages a grouping of data.

BEGIN PL/SQL statement used as an opening statement of a PL/SQL block's executable section.

BREAK SQLPLUS command that performs the action that is specified in the BREAK command. This command is used within a script.

BTITILE SQLPLUS command ...

Get Practical Guide to using SQL in Oracle now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.