Question: Why is there an error at line 2? SQL> SET ECHO ON SQL> SPOOL c: AppWA2spool.txt SP2-0768: Illegal SPOOL command Usage: SPOOL { | OFF

Why is there an error at line 2?

SQL> SET ECHO ON SQL> SPOOL c:\ App\WA2spool.txt SP2-0768: Illegal SPOOL command Usage: SPOOL { | OFF | OUT } where is file_name[.ext] [CRE[ATE]|REP[LACE]|APP[END]] SQL> SPOOL c:\App\WA2spool.txt SQL> START c:\App\WA2.txt SQL> COLUMN DEPARTMENT_ID FORMAT 99999 HEADING 'Department ID'; SQL> COLUMN EMPLOYEE_ID FORMAT 99999 HEADING 'Employee ID'; SQL> COLUMN FIRST_NAME HEADING 'First Name'; SQL> COLUMN LAST_NAME HEADING 'Last Name'; SQL> COLUMN SALARY FORMAT 9,999.99 HEADING 'Salary'; SQL> SET LINESIZE 200; SQL> SET PAGESIZE 50; SQL> TTITLE LEFT 'CS4210 Seminar 2 Written Assignment'; SQL> BREAK ON DEPARTMENT_ID; SQL> COMPUTE SUM OF SALARY ON DEPARTMENT_ID; SQL> COMPUTE SUM OF SALARY; SP2-0088: missing ON keyword SQL> SELECT DEPARTMENT_ID, EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY 2 FROM HR.EMPLOYEES 3 WHERE DEPARTMENT_ID < 50 4 ORDER BY DEPARTMENT_ID; FROM HR.EMPLOYEES * ERROR at line 2: ORA-00942: table or view does not exist

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!