[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
Pressing Ctrl + . should show you a list of available tables. For example typing: SELECT * FROM U and then pressing Ctrl + . should show you a list of all the tables starting with “U”
SELECT * FROM ALL_source WHERE UPPER(text) LIKE ‘%BLAH%’ EDIT Adding additional info: SELECT * FROM DBA_source WHERE UPPER(text) LIKE ‘%BLAH%’ The difference is dba_source will have the text of all stored objects. All_source will have the text of all stored objects accessible by the user performing the query. Oracle Database Reference 11g Release 2 (11.2) … Read more
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
select sequence_owner, sequence_name from dba_sequences; DBA_SEQUENCES — all sequences that exist ALL_SEQUENCES — all sequences that you have permission to see USER_SEQUENCES — all sequences that you own Note that since you are, by definition, the owner of all the sequences returned from USER_SEQUENCES, there is no SEQUENCE_OWNER column in USER_SEQUENCES.
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 …;