SQL Developer Script Column Output Format

Question

Currently when i run a script in sql developer it looks like this:

Script output:

However, I need it to look something like, as shown below, with the columns printed next to one another:

Example:

Thanks, help is appreciated

Assuming that you really want text output rather than the much more common grid output, column "Recipe Name" format a30 will use 30 characters to display the "Recipe Name" column (longer names would wrap to the next line). — Justin Cave
– Justin Cave, Commented May 29, 2016 at 5:43

gmiley · Accepted Answer · 2016-05-29 06:11:07Z

4

You can specify different output formats using SET sqlformat <format>:

SET sqlformat ansiconsole;

Set that prior to your sql query and you should get a nicer format. If you look into the sqlformat option, there are others you can use, but ansiconsole is likely the one you want.

Then later, if you like, you can use UNSET on sqlformat to revert back to what you had previously.

UNSET sqlformat;

edited May 29, 2016 at 6:11

answered May 29, 2016 at 5:32

gmiley

6,6041 gold badge15 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ZygD Over a year ago

I have the same problem. This doesn't seem to take effect. No matter which sqlformat I choose I always get items on separate lines... I also tried changing linesize, but for some reason it doesn't get changed at all.

Nelson Over a year ago

The UNSET command is no longer valid in later versions. To reset it, the new command is SET SQLFORMAT DEFAULT;

Collectives™ on Stack Overflow

SQL Developer Script Column Output Format

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related