Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started