chap6_refcursor_003.gif shows the top of the SQL Commands page.

The Oracle Database XE logo appears on the left side of the header. Home, Logout, and Help icons appear in the right side of the header. The current user, HR, is displayed under the logo.

Horizontal lines separate the header and body content. Immediately under the separator, a navigation breadcrumb appears on the left side, and a schema list field appears on the right side. The navigation breadcrumb displays Home > SQL > SQL Commands. The schema currently selected is HR.

The majority of the body is taken up by the editor pane. It contains the statements

CREATE OR REPLACE PACKAGE BODY cv_types AS
  PROCEDURE get_employees(deptid in number,
                          employees in out empinfotyp)
  IS
  BEGIN
    OPEN employees FOR
      SELECT employee_id,
        substr(first_name,1,1) || '. '|| last_name as employee_name,
        hire_date,
        to_char(salary, '999G999D99') as salary,

A vertical scrollbar on the right side of the editor pane indicates there is unseen content.

Immediately above the editor pane are the following:

• Autocommit check box, which is checked.

• Display list, which shows the value 10.

• Save and Run buttons. The mouse cursor is on the Run button.