OraFAQ Forum: Reports & Discoverer » How to use "include" in Oracle discoverer ?

Home » Developer & Programmer » Reports & Discoverer » How to use "include" in Oracle discoverer ?

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

How to use "include" in Oracle discoverer ? [message #304240]

Tue, 04 March 2008 11:03

itzikma
Messages: 6
Registered: August 2007

Junior Member

Hi,

I'm using oracle discoverer and I'm trying to find the function INCLUDE.

For example:

I have a field that contains (in long string) "LC" or "SIGHT" or "Imm"

In the caculate filed
If includes "LC" put "OK"
If includes "SIGHT" put "OK"
If NOT put "NOT OK"

Can you help me please ?

10x Itzik

[Updated on: Tue, 04 March 2008 14:07]

Report message to a moderator

Re: How to use "include" in Oracle discoverer ? [message #304483 is a reply to message #304240]

Wed, 05 March 2008 06:34

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

I think you're looking for the function instr (instring), combined with a decode or case when for the different options.

You can look these up in the SQL reference and use them in a Discoverer calculation.

[Updated on: Wed, 05 March 2008 06:35]

Report message to a moderator

Re: How to use "include" in Oracle discoverer ? [message #304587 is a reply to message #304483]

Wed, 05 March 2008 13:52

itzikma
Messages: 6
Registered: August 2007

Junior Member

10x

Report message to a moderator

Previous Topic:	A printing report without colors !!!!!!!!!!
Next Topic:	From a pdf Report, How to diplay hyperlink result in a second window

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 21:45:59 CST 2024