Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Developer Question

Re: Oracle Developer Question

From: Paul Dorsey <pdorsey.dulcian_at_worldnet.att.net>
Date: 1998/10/15
Message-ID: <703hfn$c3p@bgtnsc01.worldnet.att.net>#1/1

Nothing pretty.
1) You can use a wierd default where clause, e.g. empid in (select min(empid) from emp

                  group by deptno))

2) You could hook your block to a view.
3) And for the truely twisted, you can relay on the fact that forms does not display records where a pop list fails. Put in a poplist that is not displayed in the block connected to empid with only the values from 1) in it.
I.M. Snyder figured that one out.

Solution 3) avoids the subquery so may be faster in some cases.

--
Paul Dorsey
Dulcian, Inc.
www.dulcian.com
212 595 7223
Alnoor Issa wrote in message <3622CD23.C83E41F7_at_mail.idt.net>...

>
>
>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 Thu Oct 15 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US