command "break"

osvald

Member²
hi ! I wonder: why I've no effect when i use command: break on "column_name" in command window ? it must be so or not ? I think this is something wrong, because when i use command: column "column_name" noprint -- i have a result -- the column i've defined no print in results.
here's my code:

Code:
break on ai.owner skip 1
select ai.owner
      ,ai.index_name
  from all_indexes ai;
and here' reults;

Code:
OWNER                          INDEX_NAME
------------------------------ ------------------------------
scott                          IX_1
scott                          IX_2
user_1                         ix_11
user_1                         ix_12
instead of this i would like to somthing like this:

Code:
OWNER                          INDEX_NAME
------------------------------ ------------------------------
scott                          IX_1
                               IX_2
user_1                         ix_11
                               ix_12
 
The break command (and other report options) are not supported in the Command Window. For reporting functionality you can use the Report Window instead.
 
Back
Top