Task 3: Create(Enter) new product by using a Procedure with IN Parameters Follow these steps to create a procedure that allows a company employee to add a new product to the database. This procedure needs only IN parameters. In SQL Developer, create a procedure named PROD_ADD_SP that adds a row for a new product in the BB_PRODUCT table. Keep in mind that the user provides values for the product name, description, image filename (use same template for file name as ‘roasted.jpg’ or ‘double-roasted.jpg’ ) , price, and active status. Address the input values or parameters in the same order as in the preceding sentence. Call the procedure with these parameter values: ('Roasted Blend', 'Well-balanced mix of roasted beans, a medium body', 'roasted.jpg',9.50,1). Check whether the update was successful by querying the BB_PRODUCT table. -This will be a page where you allow new product information to be entered into Edit box by end user and then there will be INSERT or ADD Product button to save them by calling this Stored Procedure. -And Once your Product add tasks is completed GUI will bring the full product list with newly added one at the below part of your screen -Also there should be only one Product Search capability in the same Page. On the same page,(maybe in different part of your page) open a edit box and accept product name and search based on that product name and bring to list on screen. This below one is a sample screen (You don’t have to make same exact one) Task 4: Adding Descriptions for Order Status Codes When a shopper returns to the Web site to check an order’s status, information from the BB_BASKETSTATUS table is displayed. However, only the status code is available in the BB_BASKETSTATUS table, not the status description. We also need Description of order status. Create a function named STATUS_DESC_SF that accepts a stage ID and returns the status description. The descriptions for stage IDs are listed in below chart. Test the function in a SELECT statement that retrieves all rows in the BB_BASKETSTATUS table for basket 4 and displays the stage ID and its description. In the GUI, you should have one edit box accept idBasket as 4 ( or 5) and then you should find stage ID for this idBasket = 4 and understand and return to GUI description.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Task 3: Create(Enter) new product by using a Procedure with IN Parameters
Follow these steps to create a procedure that allows a company employee to add a new
product to the
- In SQL Developer, create a procedure named PROD_ADD_SP that adds a row for a new
product in the BB_PRODUCT table. Keep in mind that the user provides values for the
product name, description, image filename (use same template for file name as ‘roasted.jpg’ or ‘double-roasted.jpg’ ) , price, and active status. Address the input values or parameters in the same order as in the preceding sentence.
- Call the procedure with these parameter values: ('Roasted Blend', 'Well-balanced
mix of roasted beans, a medium body', 'roasted.jpg',9.50,1).
- Check whether the update was successful by querying the BB_PRODUCT table.
-This will be a page where you allow new product information to be entered into Edit box by end user and then there will be INSERT or ADD Product button to save them by calling this Stored Procedure.
-And Once your Product add tasks is completed GUI will bring the full product list with newly added one at the below part of your screen
-Also there should be only one Product Search capability in the same Page. On the same page,(maybe in different part of your page) open a edit box and accept product name and search based on that product name and bring to list on screen.
This below one is a sample screen (You don’t have to make same exact one)
Task 4: Adding Descriptions for Order Status Codes
When a shopper returns to the Web site to check an order’s status, information from the
BB_BASKETSTATUS table is displayed. However, only the status code is available in the
BB_BASKETSTATUS table, not the status description. We also need Description of order status.
Create a function named STATUS_DESC_SF
that accepts a stage ID and returns the status description. The descriptions for stage IDs
are listed in below chart. Test the function in a SELECT statement that retrieves all rows in the
BB_BASKETSTATUS table for basket 4 and displays the stage ID and its description.
In the GUI, you should have one edit box accept idBasket as 4 ( or 5) and then you should find stage ID for this idBasket = 4 and understand and return to GUI description.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
