I have the following SQL statement: SELECT CONNECT_BY_ROOT ANIMAL_ID \"ORIGINAL_ANIMAL\" , ANIMAL_ID, LINE_ID, SIRE_ANIMAL_ID, DAM_ANIMAL_ID,
I have a database table, with people identified by a name, a job and a city.I have a second table that contains a hierarchical representation of every job in the company in every city.
Oracle SQL can do hierarchical queries since v2, using their proprietary CONNECT BY syntax. In their latest 11g release 2, they added recursive subquery factoring, also known as the recursive with cla
加载中,请稍侯......