search

vrajjmehta / ObjectRelationalDB-Albums

1 stars 0 forks source link

Create Function discountPrice() #1

Open vrajjmehta opened 5 years ago

vrajjmehta commented 5 years ago

Implement the method discountPrice() that returns a discounted price using the following business rule: a. for audio CDs released more than one year ago the discount is 20% b. for vinyl records released more than one year ago the discount is 15% c. for MP3 downloads released more than two years ago the discount is 10%

vrajjmehta commented 5 years ago

create or replace type body disk_type as overriding member function discountPrice return number is discountPrice number;