Need help on format for query output

BeverlyABeeman-Oracle May 17, 2013 12:14 PM

I am new to SQL Developer.

When I run a query in the worksheet, sometimes the results are in table format and sometimes they are in text format. I would like to have the output always in table format, as it is easier to save to Excel that way.

Is there a setting for this? Or can someone explain to me what triggers the format to change for some queries?

I am using SQL D 3.1.07 Build MAIN-07.42 and accessing an instance on 11.2.0.2.

1. Re: Need help on format for query output

Gary Graham-Oracle May 17, 2013 12:40 PM (in response to BeverlyABeeman-Oracle)

Hi,

Welcome to the forum!

If you look carefully at the worksheet's toolbar, you will notice two green arrowhead icons on the left side: one larger and one smaller imposed over a lined paper image. How they work:
1. The larger renders the query result in a grid format (what you call table format). Hover over it with the mouse and see: Run Statement (Ctrl+Enter)
2. The smaller renders the query result in script output format. Hover over it with the mouse and see: Run Script (F5)

Regards,
Gary
SQL Developer Team

Edited by: Gary Graham on May 17, 2013 10:38 AM
Also, if you use Run Statement to execute code that is inherently script-like, it will treat as if you used Run Script
Like Show 0 Likes (0)

Actions