Skip to Main Content

SQL & PL/SQL

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!

BREAK not working in SQL+ for windows. Works in SQL+ in DOS

ScottyHAug 12 2010 — edited Aug 12 2010
I'm writing a simple query in SQL+
SELECT table_name, column_name
FROM user_tab_columns
WHERE table_name like 'MYTAB%'
I first set BREAK ON table_name

then I run my query.

I expect the table name to be shown once, per table, not once per column.

If I run this query in SQL+ in a DOS window, that's exactly what happens.

If I run the same thing in SQL+ for Windows (version 10 on an 11g db) the break command appears to be ignored.


Any ideas ??

Thanks folks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2010
Added on Aug 12 2010
2 comments
728 views