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 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.
