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: 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 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: Wed Apr 26 20:54:31 CDT 2017

Total time taken to generate the page: 0.10237 seconds