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

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

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

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;
Resolution

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

TMB-1613

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title