You are here: PSPad forum > English discussion forum > Oracle SQL code explorer: "sequence" keyword issue

Oracle SQL code explorer: "sequence" keyword issue

#1 Oracle SQL code explorer: "sequence" keyword issue

Posted by: metrino | Date: 2016-10-28 07:56 | IP: IP Logged

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:
_owner
s
_owner
_name

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

Options: Reply | Quote | Up ^


#2 Re: Oracle SQL code explorer: "sequence" keyword issue

Posted by: pspad | Date: 2016-11-24 11:58 | IP: IP Logged

Fixed. Available in next build

Options: Reply | Quote | Up ^






Editor PSPad - freeware editor, © 2001 - 2024 Jan Fiala, Hosted by Webhosting TOJEONO.CZ, design by WebDesign PAY & SOFT, code Petr Dvořák, Privacy policy and GDPR