History History executable file · 83 lines (83 loc) · 2.78 KB master Breadcrumbs SQLscripts / ...

Open Oracle Developer. Click "View" and then click "Dbms Output." Click the green "+" sign in the window that opens and select the database connection from which you want output.

The next example uses the SQL procedure to query the DB2 table INTERNAT for information on international flights with over 200 passengers. Note that output can be sorted by using a PROC SQL query and ...

– The multiplication operator is *, not x, as shown in line 2. – The ANNUAL SALARY alias cannot include spaces. The alias should read ANNUAL_SALARY or be enclosed in double quotation marks. – A comma ...