Oracle 11g PL/SQL Programming

An analyst in the quality assurance office reviews the time elapsed between receiving an order and shipping the order. Any orders that havent been shipped within a day of the order being placed are investigated. Create a function named ORD_SHIP_SF that calculates the number of days between the baskets creation date and the shipping date. The function should return a character string that states OK if the order was shipped within a day or CHECK if it wasnt. If the order hasnt shipped, return the string Not shipped. The IDSTAGE column of the BB_BASKETSTATUS table indicates a shipped item with the value 5, and the DTSTAGE column is the shipping date. The DTORDERED column of the BB_BASKET table is the order date. Review data in the BB_BASKETSTATUS table, and create an anonymous block to test all three outcomes the function should handle.