Home » Developer & Programmer » Forms » I want a plsql code for my problem (and similar) (merged)
I want a plsql code for my problem (and similar) (merged) [message #218484] Thu, 08 February 2007 06:42 Go to next message
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





Re: writing a PROCEDURE code for the form [message #218497 is a reply to message #218484] Thu, 08 February 2007 07:56 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I WANT IT IMMEDIATELY.
./fa/2115/0/
Procedure to solve one problem [message #218723 is a reply to message #218484] Fri, 09 February 2007 10:02 Go to previous messageGo to next message
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&regards,
sudheer mail id: sudheerkumar96@yahoo.co.in















Re: Procedure to solve one problem [message #218725 is a reply to message #218723] Fri, 09 February 2007 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>its very urgent for my project sir.
Why is it urgent for ME to solve this homework problem for YOU?

With advice, you can have it good, fast, or cheap. Pick any TWO, please.
Re: Procedure to solve one problem [message #218729 is a reply to message #218725] Fri, 09 February 2007 10:17 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Ah, it is only urgent now.
You used to "WANT IT IMMEDIATELY."
Re: writing a PROCEDURE code for the form [message #218874 is a reply to message #218484] Sun, 11 February 2007 17:28 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem? Have you found out how to turn 'Caps Lock' off?

David
I want a plsql code for my problem [message #218975 is a reply to message #218484] Mon, 12 February 2007 05:55 Go to previous messageGo to next message
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&regards,
sudheer.



Re: I want a plsql code for my problem [message #218991 is a reply to message #218975] Mon, 12 February 2007 07:11 Go to previous message
Littlefoot
Messages: 20891
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.
Previous Topic: Problem in open Template Form
Next Topic: error web client version too old
Goto Forum:
  


Current Time: Sun Dec 04 00:34:24 CST 2016

Total time taken to generate the page: 0.08226 seconds