Home » Developer & Programmer » Reports & Discoverer » How to use "include" in Oracle discoverer ?
How to use "include" in Oracle discoverer ? [message #304240] Tue, 04 March 2008 11:03 Go to next message
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 Go to previous messageGo to next message
skooman
Messages: 912
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 Go to previous message
itzikma
Messages: 6
Registered: August 2007
Junior Member
10x
Previous Topic: A printing report without colors !!!!!!!!!!
Next Topic: From a pdf Report, How to diplay hyperlink result in a second window
Goto Forum:
  


Current Time: Sun Dec 04 04:16:34 CST 2016

Total time taken to generate the page: 0.11381 seconds