'ORA-00922: Missing or Invalid option for SET FEEDBACK OFF in TOAD

I am using TOAD application to execute my query which you can see below:

SET FEEDBACK OFF;

SELECT * FROM TABLENAME 
-- and then rest of the queries

I used SET FEEDBACK OFF in Toad app (by Quest Software) as an alternative to SET NOCOUNT ON in SQL, but it shows error and says:

ORA-00922: Missing or Invalid option

Is there any alternative to SET NOCOUNT ON that we write in SQL for Oracle?

sqloracletoad


Solution 1:[1]

SET set of commands - in Oracle - was originally related to its command-line tool named SQL*Plus. It (the SET) works in some other tools, such as Oracle's GUI - SQL Developer.

Mathguy showed me that TOAD recognizes quite a lot SQL*Plus commands (I thought it does not); it is the way you run code in TOAD:

  • if you run it as a separate command, it won't work:

    enter image description here

  • on the other hand, if you run it as a script, then it works, and the result is displayed in its "Script output" tab:

    enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions