The statement you’re executing is valid. The error seems to mean that Toad is including the trailing semicolon as part of the command, which does cause an ORA-00911 when it’s included as part of a statement – since it is a statement separator in the client, not part of the statement itself. It may be … Read more
[Gathering the answers in the comments] The problem is that the Oracle service is running on a IP address, and the host is configured with another IP address. To see the IP address of the Oracle service, issue an lsnrctl status command and check the address reported (in this case is 127.0.0.1, the localhost): (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) … Read more
Just use multiple in-clauses to get around this: select field1, field2, field3 from table1 where name in (‘value1’, ‘value2’, …, ‘value999’) or name in (‘value1000’, …, ‘value1999’) or …;
According Oracle these locations are searched for tnsnames.ora, resp. sqlnet.ora and ldap.ora: Oracle Net files in present working directory (PWD/CWD) TNS_ADMIN defined sessionally or by user-defined script TNS_ADMIN defined as a global environment variable TNS_ADMIN defined in the registry Oracle Net files in %ORACLE_HOME/network|net80\admin (Oracle default location) However, I am not sure whether each application/driver … Read more