Oracle Developer Question

From: Alnoor Issa <issa_at_mail.idt.net>
Date: 1998/10/12
Message-ID: <3622CD23.C83E41F7@mail.idt.net>#1/1

Hello,

I am working on a Form(4.5) with one simple Block, for e.g EMPLOYEE Block. I have selected ONLY deptno on my block.
I would like to select only DISTINCT deptno for my employee block. Currently I am getting multiple deptno. Is there any way to use " Select distinct deptno from employee" and show the values on the employee block?

I was thinking of using On-Select trigger but it did not work.

I will very much appreciate if someone can help me in this regard.

Thank you.

Alnoor Issa
issa_at_idt.net Received on Mon Oct 12 1998 - 00:00:00 CDT