Home » SQL & PL/SQL » SQL & PL/SQL » Typical Function (oralce (i)
icon4.gif  Typical Function [message #395315] Wed, 01 April 2009 02:20 Go to next message
ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
Hi All,
I have got one requirement if i have one function with two parameter both are string
first one is Rule and second one is approval.For Example if there are three variables A,B,C,D
the rule string is follows '(A&&B)||C,D' it can be anything combanation of && and ||.
Scenerio I :
Rule String : '(A&&B)||C,D'

Approval output I needed
A B||C
B A||C
C D
D 'approved'

Scenerio II :
Rule String : '(A||B)&&C,D

Approval Output String I needed
A C
B C
C A||B
D 'approved'

anything in rule comes it is just two senerio it can be anything combanation of && and ||

can anyone can make this typical function or suggest to achieved the output which i needed.
Re: Typical Function [message #395398 is a reply to message #395315] Wed, 01 April 2009 05:22 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Without quite a bit more explanation about what the processing you're doing is, I suspect the answer is 'No'

What input will you provide to this function, and what output will you expect.

What are the meanings, in this context, of && and ||

When you are composing the long and detailed reply that you need to get further help on this problem, try to imagine that we know absolutely nothing about the problem that you've got, and what you are trying to do, and that the only information we have about it is what you tell us.
Re: Typical Function [message #395424 is a reply to message #395398] Wed, 01 April 2009 07:23 Go to previous message
ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
bascially there are two input parameter in this function one is rule {(A||B)&&C} other is the string(A).

for more detail thing the first string is the rule for approval any document{(A||B)&&C} IT MEANS if A is the user log in he can approved the document after that document goes to C as either A or B can approval so A has approved.

Ex 1
rule : (A||B)&&C ---1 INPUT STRING
USER : A --2 INPUT STRING
THE OUTPUT I NEED IS C

like that if B is out 2 string the same output i needed.
but if C log in and approved i need the output (A||B).

The rule can be anything like (A&&B)||C but only as the combination of && and || which basically means And or. in our boolean so it functionality is same as we do in our boolean.


I have made Half.
Previous Topic: Inconsistent Datatypes
Next Topic: Building a list of dates
Goto Forum:
  


Current Time: Sun Dec 04 00:20:18 CST 2016

Total time taken to generate the page: 0.12229 seconds