Question: Create the below in Oracle Apex: Create one table called it Your name with at least four attributes. Your table should contain Id, name attribute.
Create the below in Oracle Apex:
- Create one table called it Your name with at least four attributes. Your table should contain Id, name attribute. Insert your data into this table.
- Create cursor to get all information of your table.
- Create a view that can display all table data. Rename your view by your id.
- Write an SQL statement to return some data from your table. The query must use:
- ANY aggregation function (max, min, count, )
- the GROUP BY statement
- the HAVING statement
- Create trigger that can update any value after insert operation.
- Create a package specification and body called it by your name that contain the following:
-
- A Procedure that can insert new data into the table.
- A Function that can get the number of your table records.
- Create application with your name that contain the following pages:
- Create a form, name it with your name using your created table. Your form should contain the following requirements:
- One of form item should be as a list and add static list.
- Four buttons with action operation (Insert, Update, Delete, Cancel)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
