From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Query output as grid or script

Query output as grid or script - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Query output as grid or script

“

- [Instructor] Another important concept to understand about Oracle SQL Developer is the difference between query result and script output. When you write your SQL query and execute it by pressing on the green Play button, you will be presented with a Query Result tab at the bottom part of your screen displaying the output in an easy-to-read grid format. However, if you highlight the same SQL query but press the Run Script button, you will be presented with the same output but as a plain text script output. Note the results are presented in a Script Output tab at the bottom part of the screen instead of a Query Results tab. Note the difference between both tabs.

Contents