CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
isa
isa

Reputation: 141

How do I view results as text, as opposed to worksheet view in Oracle SQL Developer?

I can only get results from running SQL queries in the worksheet view. I want to view it as text. I know this was possible in past releases.

Upvotes: 14

Views: 7023

Answers (2)

Rob Kielty
Rob Kielty

Reputation: 8172

Here's a workaround

To get a text copy of the Worksheet View including Headers.

  1. Click on any cell in the worksheet view.

  2. Press CTRL-A then CTRL-SHIFT-C

The contents of the worksheet view are now presents as text and can be pasted elsewhere.

Upvotes: 10

eaolson
eaolson

Reputation: 15090

I think you want the "Run Script" (F5) command rather than the "Run Statement" (Ctrl-Enter) command.

Upvotes: 14

Related Questions