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!

Printing a blank line??

636453Jul 11 2008 — edited Mar 1 2012

Hello!! :)

I have a table called employees, it has the following column:

JOBTITLE
-----------------
Accountant
Accountant
Accountant
Accountant
Clerk
Clerk
Salesman
Salesman
Salesman
Salesman
Salesman

What i would like to do is print a blank like between the differents groups, i.e:

Accountant
Accountant
Accountant
Accountant

Clerk
Clerk

Salesman
Salesman
Salesman
Salesman
Salesman
*************************

Any ideas anyone??

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2012

Added on Jul 11 2008

14 comments

12,993 views