Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 29 2012
Added on Jul 11 2008
14 comments
12,890 views