Assignment is to use Oracle 11g PL/SQL to create a package named test_value_pkg that contains 2 overloading functions. The function should be named test_value_pf and return a BOOLEAN value. The first function accepts a date input and returns TRUE if the date is less than or equal to today's date and FALSE if it is greater than today's date. The second function accepts a number and returns TRUE if the number is less than or equal to 0 and FALSE if it is greater than 0.

The tables needed can be created with attached c10_BBcreate.sql

 

DROP TRIGGER fire_two_trg;DROP TRIGGER fire_one_trg;DROP VIEW bb_basketitem_vu;DROP VIEW bb_ship_vu;DROP TABLE bb_department CASCADE CONSTRAINTS;DROP TABLE bb_product CASCADE CONSTRAINTS;DROP TABLE bb_productoption CASCADE CONSTRAINTS;DROP TABLE bb_productoptiondetail CASCADE CONSTRAINTS;DROP TABLE bb_productoptioncategory CASCADE CONSTRAINTS;DROP TABLE bb_basketitem CASCADE CONSTRAINTS;DROP TABLE bb_basket CASCADE CONSTRAINTS;DROP TABLE bb_shopper CASCADE CONSTRAINTS;DROP TABLE bb_basketstatus CASCADE CONSTRAINTS;DROP TABLE bb_tax CASCADE CONSTRAINTS;DROP TABLE bb_shipping CASCADE CONSTRAINTS;DROP TABLE bb_promolist CASCADE CONSTRAINTS;DROP TABLE bb_promo CASCADE CONSTRAINTS;DROP TABLE bb_test1 CASCADE CONSTRAINTS;DROP TABLE bb_test2 CASCADE CONSTRAINTS;DROP TABLE bb_prod_sales CASCADE CONSTRAINTS;DROP TABLE bb_shop_sales CASCADE CONSTRAINTS;DROP TABLE bb_audit_logon CASCADE CONSTRAINTS;DROP TABLE bb_product_request CASCADE CONSTRAINTS;DROP TABLE bb_blocktest CASCADE CONSTRAINTS;DROP TABLE bb_trans_log CASCADE CONSTRAINTS;DROP TABLE bb_log_excepts;DROP SEQUENCE logid_seq;DROP SEQUENCE bb_prodid_seq;DROP SEQUENCE bb_shopper_seq;DROP SEQUENCE bb_poption_seq;DROP SEQUENCE bb_idbasket_seq;DROP SEQUENCE bb_idbasketitem_seq;DROP SEQUENCE bb_status_seq;DROP SEQUENCE bb_prodreq_seq;CREATE TABLE BB_Department (idDepartment number(2),DeptName varchar2(25) ,DeptDesc varchar2(100) ,DeptImage varchar2(25) ,CONSTRAINT dept_id_pk PRIMARY KEY(idDepartment) );insert into bb_departmentvalues(1,'Coffee','Many types of coffee beans','coffee.gif');insert into bb_departmentvalues(2,'Equipment and Supplies','Coffee makers to coffee filtersavailable','machines.gif');insert into bb_departmentvalues(3,'Coffee Club','Benefits of our club membership?','club.gif');CREATE TABLE BB_Product (idProduct number(2) ,ProductName varchar2(25) ,Description varchar2(100) ,ProductImage varchar2(25),Price number(6,2),SaleStart date,SaleEnd date,SalePrice number(6,2),Active number(1),Featured number(1),FeatureStart date,FeatureEnd date,Type char(1),idDepartment number(2),CONSTRAINT prod_id_pk PRIMARY KEY(idProduct),CONSTRAINT prod_idDept_fk FOREIGN KEY (idDepartment)

ComputerScienceExpert

(11)

Status NEW Posted 25 May 2017 08:05 AM My Price 8.00

-----------

Attachments

file 1495700147-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer