Sqlplus connecting to same database as toad application, returns correct results for:
show parameter global_name;
However, when I run "show parameter global_name;" in Toad, I get ORA-00900: invalid SQL statement.
I do not understand why this is happening?
There are two ways to execute in the Editor. Execute statement at caret (F9) and Execute script (F5).
F9 can handle all traditional SQL statements and compile PL/SQL, but it generally does not handle SQL*Plus commands.
F5, on the other hand, emulates SQL*Plus in most regards. If you run the statement with F5 you will get results.
You can also query V$PARAMETER using F9... select * from v$parameter where name = 'global_names'