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

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?

CodePudding user response：

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:
on the other hand, if you run it as a script, then it works, and the result is displayed in its "Script output" tab: