SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Plus script output not displaying when run in SQL Developer

E LangfordJun 5 2013 — edited Jun 12 2013

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

This post has been answered by Gary Graham-Oracle on Jun 7 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2013

Added on Jun 5 2013

#script, #sql-developer, #sqldeveloper, #sqlplus

12 comments

7,896 views