| PL/SQL function (merged) [message #307616] |
Wed, 19 March 2008 05:18  |
user71408
Messages: 585
Registered: November 2007
Location: NE
|
Senior Member |
|
|
Hi all,
I have 3 systems. X,Y,Z. Goods are sending to X and from X to Y and from Y to Z. as is from Z to Y and Y to X.
X Y Z
---- ---- ------
100 200 300
400 320 230
Here Y treated 100 as 200 and Z treated 200 as 300.
The process is as follows.
X Y Z
--------------------
200 200 100 ( Here X will send Goods from 200 to
| Y.But Y can understood 200 as 100.so
| it'll send the good as 100 and
| again send it to Z)
|
|
100
Now what's the requirement is
X Y Z
-------------------
300 200 100 ( X will send goods from 300(but it's
value of Z.But Y understood 300 as
200 )
|
|
|
100
for this process I have to write a function. Can any one pls give me any idea for this issue.pls let me know if any queries.
Thank you.
[Updated on: Mon, 24 March 2008 02:32] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: pl/sql function [message #307625 is a reply to message #307624] |
Wed, 19 March 2008 05:30  |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
I really start to believe he was hired by someone to drive Oracle users nuts.
Either that, or he has set up some sort of consultancy where people ask him questions, and he repeats the questions here without understanding them OR the answers.
|
|
|
|
| Re: pl/sql function [message #307626 is a reply to message #307624] |
Wed, 19 March 2008 05:31 |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
It would appear that he wants to create some kind of artificial intelligence so that
| Quote: |
Y can understood 200 as 100.so it'll send the good as 100 and again send it to Z)
|
I'm subscribed to this thread just to see what happens (it's better than watching soaps on TV)
|
|
|
|
|
|
|
|
| Re: pl/sql function [message #307649 is a reply to message #307638] |
Wed, 19 March 2008 06:15 |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Also, you generally don't need to write perfect English. Just be clear about :
1. What is the DATA
2. What is the TABLE STRUCTURE
(With create table and insert scripts when needed)
3. What is the DESIRED LOGIC
4. What is the EXPECTED RESULT
all of which is impossible to figure out in your post. The only thing I managed to get was that three somethings send other somethings between themselves, but they don't know really what they are sending, so they have to guess at some point with no logic behind it that I can see.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: oracle function [message #308364 is a reply to message #308361] |
Mon, 24 March 2008 02:34 |
 |
Michel Cadot
Messages: 67769
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Ok, I have modified it but I have to say it was sarcasm both titles are useless and don't help to know the purpose of the topic... hmmm... even the posts in the topic don't help to know what is the purpose... so it is a good title... at least consistent.
Regards
Michel
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
