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.