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
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
