12 Replies Latest reply on Jun 12, 2013 12:58 PM by E Langford

    SQL Plus script output not displaying when run in SQL Developer

    E Langford
      Hi,

      I have a script el_ccn.sql with contents..

      select count(*) from ccn;

      When I run @el_ccn.sql in a SQL Developer worksheet uising the Run Script (F5) option

      all that displays is

      COUNT(*)
      ----------

      When I run it in SQL Plus, I see..

      COUNT(*)
      ----------
      2285

      1 row selected.

      I can 'open' the script and then run it okay but I'm testing this prior to setting up more complex SQL script files, so would appreciate knowing if this can be done in SQL Developer. A colleague doesn't have access to SQL Plus, so I need to check they can do this in SQL Developer before starting an IT help call to get them SQL Plus.

      There must be something simple I'm not doing correctly.

      Many thanks, Elaine

      Edited by: E Langford on 05-Jun-2013 01:57