1 Reply Latest reply on Nov 8, 2014 2:57 AM by rp0428

    spool not returning query result

    2790968

      Hi people, I'm just beginning my adventure with sql oracle fundamentals course and I encountered first problem.

      like I wrote in topic, after running the statement I only get query itself in output file with no query result.

       

      exsample:

       

      spool C:\Users\Tomasz\Desktop\cw1.txt

      SELECT  employee_id, last_name, job_id, hire_date AS STARTDATE

      FROM employees;

      spool off;

       

      any advices?

       

      Thanks in advance,

      Tomasz.

        • 1. Re: spool not returning query result
          Hi people, I'm just beginning my adventure with sql oracle fundamentals course and I encountered first problem.

          like I wrote in topic, after running the statement I only get query itself in output file with no query result.

           

          exsample:

           

          spool C:\Users\Tomasz\Desktop\cw1.txt

          SELECT  employee_id, last_name, job_id, hire_date AS STARTDATE

          FROM employees;

          spool off;

          You said 'after running the statement'.

           

          What you posted is NOT a statement; it is a script.

           

          I select Run Script (F5) and the file contains the query and the result set.

           

          If you use 'Run Statement' you won't get a file.