Home » Other » Training & Certification » PL/SQL function (merged)
PL/SQL function (merged) [message #307616] Wed, 19 March 2008 05:18 Go to next message
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 #307624 is a reply to message #307616] Wed, 19 March 2008 05:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If someone understand that, can he explain it to me?
What does Oracle has to do with this?
What SQL has to do with this?
In what programming has to do with this?
In what computer has to do with this?

Regards
Michel
Re: pl/sql function [message #307625 is a reply to message #307624] Wed, 19 March 2008 05:30 Go to previous messageGo to next message
ThomasG
Messages: 3189
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 Go to previous messageGo to next message
pablolee
Messages: 2835
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 Go to previous messageGo to next message
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 #307638 is a reply to message #307635] Wed, 19 March 2008 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First question: In what computer has to do with this?
Second question: In what programming has to do with this?
Third question: What SQL has to do with this?
Fourth question: What does Oracle has to do with this?

Answer these questions one by one then we might understand you.

Regards
Michel
Re: pl/sql function [message #307649 is a reply to message #307638] Wed, 19 March 2008 06:15 Go to previous messageGo to next message
ThomasG
Messages: 3189
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 Go to previous messageGo to next message
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 #308317 is a reply to message #308313] Mon, 24 March 2008 01:00 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
while you may think you satisfied the posting guidelines
http://www.orafaq.com/forum/t/88153/0/

AlL I have to say is
HUH?
I have no idea about the problem or solution.
Re: oracle function [message #308344 is a reply to message #308313] Mon, 24 March 2008 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Reread your previous topic: http://www.orafaq.com/forum/m/307616/102589/#msg_307616.
My answer is the same one.
Read carefully the last post it also applies to this topic.

Regards
Michel
Re: oracle function [message #308351 is a reply to message #308344] Mon, 24 March 2008 02:04 Go to previous messageGo to next message
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 #308357 is a reply to message #308351] Mon, 24 March 2008 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, as i have absolutly no idea of what is your problem and even don't where Oracle is in your post.
This is clearly expressed by all the posters of your previous post.
I even didn't see this was the same question! I will merge the two. What's could be the title? "oracle function" or "pl/sql function"? I hesitate between the two.

Regards
Michel
Re: oracle function [message #308361 is a reply to message #308357] Mon, 24 March 2008 02:27 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Michel,

It's PL/SQL function.
Re: oracle function [message #308364 is a reply to message #308361] Mon, 24 March 2008 02:34 Go to previous message
Michel Cadot
Messages: 64139
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
Previous Topic: Need a exact queries
Next Topic: hot backup
Goto Forum:
  


Current Time: Thu Dec 08 16:11:42 CST 2016

Total time taken to generate the page: 0.14786 seconds