How do I do this Task 1 Create an Oracle APEX account using

How do I do this?:

Task 1: Create an Oracle APEX account using the instructions provided.

Task 2: Upload the SQL Script file “Hotel DB – Week10.sql” into your Oracle APEX account using “SQL Scripts” tool in your account.

Task 3: Create the following schema in your APEX account using SQL workshop.

w10 programs w10 student program id program name w10 course course code course_name course_level program_id course_details student_name birth date email student address program id (F w10 grade student no (FK) course code (FK) grade

Solution

solution:

Oracle Application Express (Oracle APEX) is a rapid Web application development tool for the Oracle Database. The browser based interface, declarative programming framework, and simple wizards make Oracle Application Express easy to learn and enable you to quickly build robust applications.
Oracle Application Express customers can readily utilize Oracle Database Vault’s strong security controls to build more secure Web applications.
This paper discusses how both Application Express and Database Vault can be integrated and configured in the Oracle database by making simple changes to Database Vault default Realms and Command rules.
Architecture
Oracle Application Express Architecture
Oracle Application Express consists of a metadata repository that stores the definitions of applications and an engine (called the Application Express engine) that performs page rendering and processing. It lives completely within the Oracle database.
The Oracle Application Express engine manages:

--session state

-- Authentication services

-- Authorization services

-- Page flow control

-- Validations, computations, and processing

-- Rendering and page processing

Oracle Application Express is installed into your Oracle database and what release is installed then perform the following steps:

1. Start SQL*Plus and connect to the Oracle Database as SYS specifying the SYSDBA role. For example: $ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password
2. Run the following SQL statement to identify any Application Express installation:
SQL> SELECT username FROM dba_users WHERE username LIKE ‘FLOWS_%’ OR username LIKE ‘APEX_%’;