portal lov question

From: Keld Nielsen <keldnielsen_at_image.dk>
Date: Mon, 18 Feb 2002 21:53:57 +0100
Message-ID: <DXdc8.1432$z7.381880_at_news000.worldonline.dk>



Hi,
config: 9ias, portal 3.0.9, nt(client)/2000(server) problem: how to construct the where clause, when creating a dynamic lov.

I'm aware that I need to use concatenate, as for example 'select a||b||c||, a'
but how to include for example 'distinct' and/or hints ?
as in 'select /*+ <a hint> */ distinct <something>'

haven't been able to find anything about the above in the docs.

Many thanks in advance,
Keld. Received on Mon Feb 18 2002 - 21:53:57 CET

Original text of this message