| 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 #307635 is a reply to message #307616] |
Wed, 19 March 2008 05:48 |
user71408
Messages: 585
Registered: November 2007
Location: NE
|
Senior Member |
|
|
Hi all
Sorry for giving incomplete mesg,,
if X value is 100. Y understood 100 as 200.bcoz Y don't know 100. Z will take if the goods are from 100 it understood 100 as 300.
Our native language is Arabic.SO I am not able to give u the details clearly in english. That's the pproblemmm...So pls understand my problem why am not giving clear picture...
Thank you,
|
|
|
|
|
|
| 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.
|
|
|
|
| oracle function [message #308313 is a reply to message #307616] |
Mon, 24 March 2008 00:54 |
user71408
Messages: 585
Registered: November 2007
Location: NE
|
Senior Member |
|
|
Hi all,
Please find the following requirement. For this I have to write a function.So can you please give me idea for this issue.
XYZ would require "godown" to replenish for these locations (80,90). Within XYZ, store is not able to generate forecasts far enough into the future for lines for these locations. These "godowns" are treated as stores within ABC (180,190) so that ABC can interfaces transqacsales etc.
ie:
SQL> select * from loc;
Godown STORE Dummy_godown
------------- ---------------- ----------------
80 50 180
90 60 190
and modify the code to translate orderis sent from XYZ to ABC for Dummy_godown locations of 180 and 190 and also translate them to 50 and 60.
Currently XYZ receives the orders from ABC as 80 and 90 which it translates to 50 and 60 prior to inserting into other tables.
Thank you.
|
|
|
|
|
|
|
|
| Re: oracle function [message #308351 is a reply to message #308344] |
Mon, 24 March 2008 02:04 |
user71408
Messages: 585
Registered: November 2007
Location: NE
|
Senior Member |
|
|
Michel .
You are right. But Here I am giving brief description. That's why I posted it again. Can you please give me idea. Then I'll solve this issue.
Thank you.
|
|
|
|
|
|
|
|
| Re: oracle function [message #308364 is a reply to message #308361] |
Mon, 24 March 2008 02:34 |
 |
Michel Cadot
Messages: 68643
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
