Oracle SQL Developer verbose output

Question

I'm currently using Oracle SQL Developer 4.0.1.14, doing something like this:

UPDATE mytable SET myfield = 'myvalue' WHERE myotherfield = 234;
INSERT INTO mytable (myfield , myotherfield) VALUES ('abc', 123);
INSERT INTO mytable (myfield , myotherfield) VALUES ('abd', 124);
...

... and many many more lines.

If one runs the whole script, one only sees output like this:

8 rows updated.
1 rows inserted.
1 rows inserted.
...

In a small script, this is not a problem, since you can easily see, which line caused which output. But if you think on a script with 1k lines, to find a "0 rows updated." and which command caused, it ends up in frustration.

So I would rather want an output like this:

> UPDATE mytable SET myfield = 'myvalue' WHERE myotherfield = 7393;
8 rows updated.
> INSERT INTO mytable (myfield , myotherfield) VALUES ('abc', 123);
1 rows inserted.
> INSERT INTO mytable (myfield , myotherfield) VALUES ('abd', 124);
1 rows inserted.
...

I know, this is possible in Sql*Plus when running a script in verbose mode. But this should also be possible in SQL Dev, shouldn't it?

I would highly appreciate if one could tell me how.

Thanks a lot!

user3278460 · Accepted Answer · 2014-04-29 09:50:07Z

5

try to use set echo on (sqlplus command which works in sql developer too), e.g.

create table t(a varchar2(100));

set echo on
update t set a = 0;
update t set a = 0;
update t set a = 0;

output is (after F5 - run script)

table T created.
> update t set a = 0
0 rows updated.
> update t set a = 0
0 rows updated.
> update t set a = 0
0 rows updated.

answered Apr 29, 2014 at 9:50

user3278460

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle SQL Developer verbose output

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related