Databases Reference
In-Depth Information
The
PASSWORD
command will prompt you for the old and new passwords. The
ALTER
USER
command does not prompt you for the old password.
Report Formatting
While a DBA or an application developer who is familiar with the data can inter-
pret terse column names such as
, these column names may
not be very intuitive for employees in the Accounting department. Similarly, con-
sider a query like this:
MGR_NO
and
ST_ID
select last_name from employees
where department_id = 80;
Its output does not make it clear that the query output is only for the Sales
department, unless you have all the department numbers memorized!
Reports generated from SQL queries are much more readable and under-
standable when you use descriptive column names and report headers and foot-
ers. The added features of the iSQL*Plus, SQL*Plus, and SQL*Plus Worksheet
environment provide this functionality.
In this section, you'll learn how to add headers and footers. You'll also find
another way to create descriptive column names. In previous chapters, the exam-
ples used column aliases to change column names in the SQL query output.
