Oracle $11$G PL$/$SQL ProgrammingAssignment $3-1$: Querying Data in a BlockA Brewbean$$s application page is being developed for employees to enter a basket number andview shipping information for the order that includes date, shipper, and shipping number. AnIDSTAGEvalue of $5$ in the BB$\_$BASKETSTATUS table indicates that the order has beenshipped. In this assignment, you create a block using scalar variables to hold the data retrievedfrom the database. Follow these steps to create a block for checking shipping information:$1.$ Start SQL Developer, if necessary$\mathrm{.}2.$ Open theassignment$03-01.$sqlfile in the Chapter$03$ folder$\mathrm{.}3.$ Review the code, and note the use of scalar variables to hold the values retrieved in theSELECTstatement$\mathrm{.}4.$ Add data type assignments to the first three variables declared. These variables will beused to hold data retrieved from a query$\mathrm{.}5.$ Run the block for basket ID$3,$ and compare the results with Figure $3-29.$Oracle $11$G PL$/$SQL ProgrammingOracle $11$G PL$/$SQL Programming