Query on hierarchical tree in Oracle Forms
Posted on 2003-02-22
1)Can you please elaborate on the SELECT....START WITH....
CONNECT BY.. CLAUSE. which we use in creating Record Group
for populating Tree.
2)Moreover my EMP table has foll. structure.
SSN NUMBER(12) NOT NULL,
SALARY NUMBER(7) NOT NULL,
DNO NUMBER(2) NOT NULL) ;
How will i modify the above SELECT....START WITH....
query to populate tree item with my EMP table.Why normal SELECT statements are not effective here.
3)Suppose user wants to create the nodes manually without populating it from any table.How he shoould go about it???
I am using Forms [32 Bit] Version 188.8.131.52.3 (Production)
Thanks in advance.