| I want a plsql code for my problem (and similar) (merged) [message #218484] |
Thu, 08 February 2007 06:42  |
sudheerkumar96
Messages: 6
Registered: December 2006
Location: INDIA
|
Junior Member |
|
|
hello sir,
I have a query for you.
this is my table BLOCKED_ANIMALS in the ANIMALS_BLCOKED FORM
1.LOADING_DATE
2.ANIMALS_BLOCKED
3.NO_OF_ANIMALS
4.ANIMALS_ALLOWED
suppose
DAY1:
ANIMALS_BLOCKED =100[I WANT TO BLCOK 100 ANIMALS TODAY]
NO_OF_ANIMALS =110[HERE I NEED TO CALCULATE THE REMAINING
ANIMALS]
ANIMALS_ALLOWED =ANIMALS_BLOCKED.
I WANT THE CODE FOR THIS LOGIC SIR.
DAY2:
ANIMALS_BLOCKED =200
NO_OF_ANIMALS=210
ANIMALS_ALLOWED=ANIMALS_BLOCKED[HERE THE REMAINING ANIMALS
WHICH ARE LEFT IN DAY ONE MUST BE ADDED TO NO_OF_ANIMALS AND
FROM THAT I WANT TO GET THE ANIMALS_ALLOWED];
DAY3:
ANIMALS_BLOCKED =100
NO_OF_ANIMALS = 80[REMAINING 20 ANIMALSFROM THE DAY1
AND DAY 2 WILL BE ADDED TO THIS NO_OF_ANIMALS]
ANIMALS_ALLOWED=?
I WANT TO WRITE ONE PROCEDURE FOR THIS LOGIC.
SO, PLS HELP ME. I WANT IT IMMEDIATELY.
PLZ!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
THANKS & REGARDS,
SUDHEER EMAIL ID :SUDHEERKUMAR96@YAHOO.CO.IN
|
|
|
|
|
|
| Procedure to solve one problem [message #218723 is a reply to message #218484] |
Fri, 09 February 2007 10:02  |
sudheerkumar96
Messages: 6
Registered: December 2006
Location: INDIA
|
Junior Member |
|
|
Hello sir,
I want to know how to write the procedure for the following problem.
THIS IS MY TABLE:
BLOCKING_ANIMALS
1.LOADING_DATE
2.ANIMALS_ALLOWED
3.NO_OF_ANIMALS_RECEIVED
4.ANIMALS_BOOKED
a)loading_date:
suppose,let us consider today's date.
b)animals_allowed:
today, I want to allow only say 100 animals(this animals_allowed vary from day to day. ie, it is not constant);
c)no_of_animals_received:
today, I have received 200 animals say,
That means, the customer has come with 200 animals,so that
I want to allow only 100 animals.
so, the remaining animals(200-100 = 100), I want to allow to the next day.
d)animals_booked:
animals_booked = 100 only(as I said earlier);
This is brief description regarding my problem.
so, my doubt is:
if suppose I want to allow 100 animals today.
The customer has brought 90 animal, say suppose
/* if no_of_animals_received <= animals_allowed then */
I want to display the no_of_animals_received.
/* if no_of_animals_received > animals_received then */
I want to display the animals which I must allow today
to block
that means, animals_booked = :animals_allowed.
so, the remaining animals will be carry forward to the next day.
see, here every day is different from the other
suppose, today
09/feb/2007
animals_allowed = 100
no_of_animals_received = 200
10/feb/2007 (next day)
animals_allowed = 200
no_of_animals_received = 150
11/feb/2007
animals_allowed = 90
no_of_animals_received = 40
12/feb/2007
animals_allowed = 110
no_of_animals_received = 110
I need to check all these cases to sort out the problem.
I want to write a procedure for this problem.
its very urgent for my project sir.
I feel great if any one try to sort out this problem.
plz!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you,
thanks®ards,
sudheer mail id: sudheerkumar96@yahoo.co.in
|
|
|
|
|
|
|
|
|
|
| I want a plsql code for my problem [message #218975 is a reply to message #218484] |
Mon, 12 February 2007 05:55 |
sudheerkumar96
Messages: 6
Registered: December 2006
Location: INDIA
|
Junior Member |
|
|
Hello sir,
I want to know how to write the procedure for the following problem.
THIS IS MY TABLE:
BLOCKING_ANIMALS
1.LOADING_DATE
2.ANIMALS_ALLOWED
3.NO_OF_ANIMALS_RECEIVED
4.ANIMALS_BOOKED
a)loading_date:
suppose,let us consider today's date.
b)animals_allowed:
today, I want to allow only say 100 animals(this animals_allowed vary from day to day. ie, it is not constant);
c)no_of_animals_received:
today, I have received 200 animals say,
That means, the customer has come with 200 animals,so that
I want to allow only 100 animals.
so, the remaining animals(200-100 = 100), I want to allow to the next day.
d)animals_booked:
animals_booked = 100 only(as I said earlier);
This is brief description regarding my problem.
so, my doubt is:
if suppose I want to allow 100 animals today.
The customer has brought 90 animal, say suppose
/* if no_of_animals_received <= animals_allowed then */
I want to display the no_of_animals_received.
/* if no_of_animals_received > animals_received then */
I want to display the animals which I must allow today
to block
that means, animals_booked = :animals_allowed.
so, the remaining animals will be carry forward to the next day.
see, here every day is different from the other
suppose, today
09/feb/2007
animals_allowed = 100
no_of_animals_received = 200
10/feb/2007 (next day)
animals_allowed = 200
no_of_animals_received = 150
11/feb/2007
animals_allowed = 90
no_of_animals_received = 40
12/feb/2007
animals_allowed = 110
no_of_animals_received = 110
I need to check all these cases to sort out the problem.
I want to write a procedure for this problem.
its very urgent for my project sir.
I feel great if any one try to sort out this problem.
plz!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you,
thanks®ards,
sudheer.
|
|
|
|
| Re: I want a plsql code for my problem [message #218991 is a reply to message #218975] |
Mon, 12 February 2007 07:11 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I merged all your topics at one place - Forms forum (as you originally started it here).
Please, stop flooding the OraFAQ forum with the same question.
Don't expect someone to give you the final code just because we like the colour of your eyes. First show us what you did - how you tried to solve the problem, difficulties you encountered and errors you got. Crying that "you need it immediately", "urgent" etc. won't help much.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
