Hi. 
I'm writing an Oracle SQL file that contains a package declaration / body.
It looks like the "sequence" keyword is mismatched in code explorer.

For instance, following statement 

SELECT _sequence_owner_ owner, sequence_name name, min_Value
     , increment_by, DECODE(cycle_flag, 'N', 'NOCYCLE', 'CYCLE') vcycle
     , DECODE(order_flag, 'N', 'NOORDER', 'ORDER') vorder
     , DECODE(cache_size,0,'NOCACHE', 'CACHE '||cache_size) vcache
FROM _all_sequences_
WHERE _sequence_owner_ = UPPER(TRIM(i_owner))
AND _sequence_name_ = NVL(UPPER(TRIM(i_sequence)),
sequence_name||'');

finds following (false positive) sequences:
[i]_owner
s
_owner
_name[/i]

I suppose you have to add a "white" char after "sequence" keyword to make it
works correctly

-- 
<http://forum.pspad.com/read.php?2,67438,67438>
PSPad freeware editor http://www.pspad.com

Odpovedet emailem