Okay, it happened again. This time, a JIRA item (RAPT-558) did not show in the All filter for the RAPT project -- or any other filter for that matters. You could load the item directly, it just didn't appear in any lists. Rebuilding the indexes corrected the problem.
Oracle, SQL*Plus, PL/SQL
SQL*Plus will behave as you expect when executing this sequence:
variable result number; update zot set x=x+1 returning x into :result; print result;
but not this sequence:
variable result number; select count(*) into :result from user_catalog; print result;
In the latter case, the SELECT statement is accepted and executed, but the INTO clause is not respected. On the other hand, you can make it work by using a PL/SQL block:
variable result number; begin select count(*) into :result from user_catalog; end; / print result;
While we're on the topic of SQL*Plus, here are some useful snippets that I haven't captured before...
set echo on whenever sqlerror exit failure define supplied_user = &&1 define supplied_tablespace = &&2 prompt Creating tables for &&supplied_user in &&supplied_tablespace declare table_count number; begin select count(*) into table_count from user_catalog where table_name='ZOT'; if 0 = table_count then execute immediate 'create table &&supplied_user..zot (x integer) ' || ' tablespace &&supplied_tablespace' ; end if; end; /
Note the two dots in "create table &&supplied_user..zot". The second dot is needed because SQL*Plus will gobble the first dot it sees after any use of the "&" operator (unless you change that behaviour using SET CONCAT).