SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue in generating bill using Oracle Programming

526ba70c-6d17-49e4-8653-445f7b519d11Aug 1 2016 — edited Aug 1 2016

I want to generate newspaper bill according to the following criteria.

In a newspaper publisher, the cost of newspaper on Tuesday and Thursday is Rs.3/- and on other days it is Rs.2/-. So my requirement is to generate billing of newspaper as per the choice of user input at runtime using Oracle Pl/SQL programming.

NOTE:

The billing can be as Daily/Weekly/Monthly/Yearly/Any specific duration based on the requirement.(For Ex. i want billing from August 2015 to March 2016)

Oracle Scheduler, Stored Procedures/Functions, Cursor, Loops can be used.

Any help will be appreciated.

Thank You

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2016

Added on Aug 1 2016

#function, #oracle, #pl-sql

4 comments

649 views