OraFAQ Forum: Forms » Checked parents that do not have checked children

Home » Developer & Programmer » Forms » Checked parents that do not have checked children

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Previous Topic:	Lock oracle`s forms
Next Topic:	OC4J is not starting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 18:14:12 CDT 2024