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: Need of Prior Quarter logic
Next Topic: How can used UNION STATMENT ACCORDING CONDITION in REPORT?
Goto Forum:
  


Current Time: Sun Aug 20 12:29:20 CDT 2017

Total time taken to generate the page: 0.08135 seconds