Home » Developer & Programmer » Forms » Checked parents that do not have checked children
Checked parents that do not have checked children [message #649346] Wed, 23 March 2016 03:30
msambasiva
Messages: 4
Registered: November 2015
Junior Member
Following are the details

desc hier_links
PARENT_ITEM_ID NOT NULL VARCHAR2(20)(PK)
CHILD_ITEM_ID NOT NULL VARCHAR2(20)(PK)

parent => child
=================
OY28(checked) => OP1397,OP1439,OP1440
OY27(checked) => OP1924(checked),OP1926,OP2832,OP2851

The data we are displaying in a Tree format with checkbox option. So the user can check the required nodes from parent or child level.

I/P: checked parents (OY28,OY27)and checked child(OP1924)
Expected O/P: checked parents that do not have checked children (OY28)

Please suggest any clue to get the expected results i.e Checked parents that do not have checked children

Thanks,
Samba.
Previous Topic: Lock oracle`s forms
Next Topic: OC4J is not starting
Goto Forum:
  


Current Time: Sat Jun 12 15:54:50 CDT 2021