1752647 Members
5576 Online
108788 Solutions
New Discussion

Re: Output formatting

 
Graham Cameron_1
Honored Contributor

Re: Output formatting

Well, it's a pretty odd request, and your example output doesn't match the stipulated format, but I think the attached will do what you're after. Save it as a .sql file and run from sqlplus.
You'll have to tweak the table and col names, (shown in upper case) as I don't know your exact ones.

-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.