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: Wojciech B³¹d <blad_at_sz.onet.pl>
Date: 1998/10/13
Message-ID: <f1GU1.1378$bY2.358828@news.tpnet.pl>#1/1

  1. Use Post-Query trigger for select data. Item for this data can not have base table property set.
  2. Define view and build block based on this view.

Regards,
Wojtek

Alnoor Issa napisa³(a) w wiadomoœci: <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 Tue Oct 13 1998 - 00:00:00 CDT

Original text of this message

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