9.6. Review Questions

  1. An iSQL*Plus substitution variable is preceded by what character(s) in a script?

  2. Identify the two iSQL*Plus commands that define the header and footer for a report.

  3. On which iSQL*Plus web page can you adjust the size of the iSQL*Plus window where you enter your iSQL*Plus commands or SQL statements?

  4. Write an iSQL*Plus footer command to display the text Page 22, right-justified on the line.

  5. Sums and averages can be displayed on an iSQL*Plus report using which iSQL*Plus command?

  6. Write a single iSQL*Plus COLUMN command to format the Salary column with a total of six digits, four to the left of the decimal point and two to the right. In the same COLUMN command, define the header to be Monthly Salary, with the words appearing on different ...

Get Oracle Database Foundations 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.

Start your free trial