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:
and here' reults;
instead of this i would like to somthing like this:
here's my code:
Code:
break on ai.owner skip 1
select ai.owner
,ai.index_name
from all_indexes ai;
Code:
OWNER INDEX_NAME
------------------------------ ------------------------------
scott IX_1
scott IX_2
user_1 ix_11
user_1 ix_12
Code:
OWNER INDEX_NAME
------------------------------ ------------------------------
scott IX_1
IX_2
user_1 ix_11
ix_12