Return
-
Title
Request for code assist for ANSI JOIN syntax (dot lookup popup window) -
Description
SQL Navigator currently does not provide context sensitive help when ANSI JOIN syntax is used. For example:
Context sensitive help is triggered when entering this SQL in the SQL editor
select c.cmn_clnt_sk
from cmn_clnt c,
cmn_clnt_indv i
where c.cmn_clnt_sk = i.cmn_clnt_indv_sk
and c.cmn_clnt_cd_sk = 5but not when the query is restructured using ANSI JOINselect c.cmn_clnt_sk
from cmn_clnt c
join cmn_clnt_indv i on c.cmn_clnt_sk = i.cmn_clnt_indv_sk
and c.cmn-clnt_cd_sk = 5Please enhance SQL Nav so it provides context-sensitive help for ANSI JOIN syntax (JOIN, RIGHT JOIN, LEFT JOIN). i.e. automatic dot lookup to support ANSI JOIN syntax
-
Resolution
WORKAROUND
none
STATUS
Enhancement request ST11659 has been submitted to Development for consideration in a future release of SQL Navigator for Oracle
-
Defect ID
ST11659