Query Builder removes CONNECT BY in sql statement when trying to reverse engineer a sql statement (4308773)

立即与支持人员聊天

反馈已提交

本文是否解决了您的问题？

选择评级

标题

Query Builder removes CONNECT BY in sql statement when trying to reverse engineer a sql statement
说明

Sending a hierearchy sql statement to the Query Builder to reverse engineer, results in the CONNECT BY clause being removed.
From the Editor, send the following query to Query Builder:
SELECT
EMPNO, ENAME, JOB,
MGR, HIREDATE, SAL,
COMM, DEPTNO
FROM SCOTT.EMP
CONNECT BY MGR=EMPNO;
The Query shows the following in Query Builder:
SELECT
EMPNO, ENAME, JOB,
MGR, HIREDATE, SAL,
COMM, DEPTNO
FROM SCOTT.EMP;
解决办法

WORKAROUND
none
STATUS
Waiting for fix in a future release of Toad for Oracle
缺陷ID

TMB-1613

反馈已提交

本文是否解决了您的问题？

选择评级

建议的内容

标题