CODEWITHSUNDEEP
oracle-databaseoracle11g
user1870400
user1870400

Reputation: 6374

How to get the grid view for query results using oracle sql developer in mac?

When I issue a query like select * from city; using oracle sql developer in mac I get the output that is not aligned and it is very hard to read. How do I get the grid view and set it as default?

Upvotes: 3

Views: 9328

Answers (2)

thatjeffsmith
thatjeffsmith

Reputation: 22467

Sounds like you're getting the script output. You can have that formatted nicely by using SET SQLFORMAT ansiconsole, we'll make the columns line up as nice as possible based on the size of the display.

enter image description here

But if you want the data back in a grid, use Ctrl+Enter or F9 or the first execute button in the toolbar to execute.

enter image description here

This will get you the output in a grid, like this:

enter image description here

I talk about both executing as a script or statement here.

Upvotes: 4

ArtBajji
ArtBajji

Reputation: 960

If your issue is with formatting, you may want to look at this link

If your issue is with records not getting inserted, please note these.

  1. Records inserted in one session will not be visible in another session unless they are committed.
  2. If you are checking the count in the same session where you inserted the records, then check for errors in insert. Add a show errors command at the end of your script, "path_to_file.sql" to check if any errors occurred while inserting the records.

Hope this helps.

Upvotes: 1

Related Questions