Q question related to break on object_type skip 1

Hi; Following is oracle sql script and its result. I do not understand what does this 'break on object_type skip 1 ' mean?
It does not mention in the book. Beginning Oracle programming. Chapter 4. Finding Out More About the Sample Schemas


==================================================================================
column object_name format a30
column tablespace_name format a30
column object_type format a12
column status format a1
break on object_type skip 1                                       <-------------------------------------what does it mean?

select object_type, object_name,
       decode(status,'INVALID','*','') status,
       tablespace_name
  from user_objects a, user_segments b
 where a.object_name = b.segment_name (+)
   and a.object_type = b.segment_type (+)
 order by object_type, object_name
/
column status format a10
OBJECT_TYPE  OBJECT_NAME                S TABLESPACE_NAME
-----------------  ------------------------------ - ------------------------------
INDEX              COUNTRY_C_ID_PK             EXAMPLE
                        DEPT_ID_PK                       EXAMPLE

PROCEDURE    ADD_JOB_HISTORY
                       SECURE_DML

SEQUENCE     DEPARTMENTS_SEQ
                      EMPLOYEES_SEQ
                      LOCATIONS_SEQ

TABLE            COUNTRIES
                     DEPARTMENTS                      EXAMPLE
                     EMPLOYEES                          EXAMPLE


TRIGGER      SECURE_EMPLOYEES
                   UPDATE_JOB_HISTORY
VIEW          EMP_DETAILS_VIEW

34 rows selected.

 

 
JianJunShenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jinesh KamdarCommented:
Setting A BREAK point
---------------------------
If you have a query that selects some repeating data, or you want to section out different rows, you
can set up a break point to do this. For example, if you have a query which simply selects the deptno
and ename columns from emp, you may want to section out rows for each department, and also only
print the department each time it changes.

Example Before
=============
DEPTNO ENAME
--------- --------
10 CLARK
10 KING
10 MILLER
20 SMITH
20 ADAMS

If you first entered:

SQL> BREAK ON deptno SKIP 1

You would have:
DEPTNO ENAME
--------- --------
10 CLARK
KING
MILLER
20 SMITH
ADAMS

The BREAK command says: set up a BREAK point on deptno and skip a line each time it changes.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SujithData ArchitectCommented:
>> break on object_type skip 1                                      
This is a formatting clause used in sqlplus reports.
BREAK ON object_type - groups together records with the same object_type and displays the object type value only for the first record.
SKIP 1 - skips one line after each group of object_types.

For this setting to work; the query used in the report should have an order by clause, in which you use order by <column used to set BREAK on>
SKIP <n> skips n lines
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.