1. Install the Oracle HR Sample Tables into your Oracle Apex workspace2. Using those tables and Oracle Apex, build a web application that allowsusersa. To view information of employees, departments, and locations for eachcorresponding table.b. To add new records of employees, departments, and locations to eachcorresponding table.c. To remove records of employees, departments, and locations from eachcorresponding table.d. To update records of employees, departments, and locations for eachcorresponding table.e. To view employees along with their department names (not departmentIDs as in a, b, c, and d) and their street addresses, cities, and countries (not location_id as in a, b, c, and d).

SQL> create table Emp(employees varchar(20),department varchar(10),address varchar(10),cities…

To view information of employees, departments, and locations for each corresponding table. To add new records of employees, departments, and locations to each corresponding table. To remove records of employees, departments, and locations from each corresponding table. To update records of employees, departments, and locations for each corresponding table. To view employees along with their department names (not department IDs as in a, b, c, and d) and their street addresses, cities, and countries ( not location_id as in a, b, c, and d).

To view information of employees, departments, and locations for each corresponding table. To add new records of employees, departments, and locations to each corresponding table. To remove records of employees, departments, and locations from each corresponding table. To update records of employees, departments, and locations for each corresponding table. To view employees along with their department names (not department IDs as in a, b, c, and d) and their street addresses, cities, and countries ( not location_id as in a, b, c, and d).

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter13: Views

Section: Chapter Questions

Problem 7MC

See similar textbooks

Similar questions

Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
Write, but do not execute, the commands to grant the following privileges: a. User Rodriquez must be able to retrieve data from the TRIP table. b. Users Gomez and Liston must be able to add new reservations and customers to thedatabase. c. Users Andrews and Zimmer must be able to change the price of any trip. d. All users must be able to retrieve the trip name, start location, distance, and type forevery trip. e. User Golden must be able to add and delete guides. f. User Andrews must be able to create an index for the TRIP table. g. Users Andrews and Golden must be able to change the structure of the CUSTOMERtable. h. User Golden must have all privileges on the TRIP, GUIDE, and TRIP_GUIDEStables.
A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
Mindtap Cengage assignment
Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA. Task 12: List all the views contained within the system catalog, but only display the first 12 records.
shows Gym ABC Sdn Bhds' customer record form which keep and manage the information of customer in database named GYM and table named Customer. The customer record consists of table heading named S.No, Name, Age, Edit and Delete. It also provide two links named Edit and Delete which performs task according to their name. Write PHP program segment to edit data in the database and to delete data in the database based on customer no. View Records Age Edit Delete 30 Edit Delete 18 S.No Name Adnan Edit Delete Edit Delete Edit Delete 23 Edit Delete 2 Imran 3 Kashif 25 4 Kamran 25 5 Javed Figure 4: Gym Customer Record
• create a sql script that loads your tables with data. Note: in addition to the data present in the table, add several more records for each table in the database, including Client's taking multiple courses and Courses with NO students having taken (think planned course). LANGUAGE SCHOOL TABLE CourseID Course Language CourseLevel ClientID ClientName Attendance FinalScore German C111 Mr. Smith Ms. Jones German German Mr. Vance German Ms. Clark German Ms. Wong German Ms. Hess Japanese Mr. Smith Japanese Ms. Jones 10 11 12 10 11 G 12 20 21 Basic Intermediate C222 Advanced C333 Basic C444 Intermediate C555 Advanced C666 Basic C111 Intermediate C222 100% 90% 95% 100% 90% 95% 100% 95% 80% 90% 100% 100% 95% 98% 100% 100%
Task 10: User Oliver must be able to retrieve data from the PROPERTY table. 1 Task 11: Users Crandall and Perez must be able to add new owners and properties to the database. 4 Task 12: Users Johnson and Klein must be able to change the monthly rent of any property.
136. Which statement is true regarding external tables? a. The default REJECT LIMIT for external tables is UNLIMITED b. The data and metadata for an external table are stored outside the database c. ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table d. The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table
Alter table product so that column productType is an integer instead of a varchar, not null should be maintained. Alter table product so that column productType is a foreign key to table productType, column id Alter table customer so that column zipCode is a foreign key to table çityState. column zipCode Alter table customer to drop column city and state Alter table employee so that column zipCode is a foreign key to table çityState. column zipCode Alter table employee to drop column city and state Alter table supplier so that column zipCode is a foreign key to table çityState, column zipCode Alter table supplier to drop column city and state
please use sql to answer the following question an erd has been provide Task 1: Creating a Logon Procedure The home page of the Brewbean’s Web site has an option for members to log on with their IDs and passwords. Develop a procedure named MEMBER_CK_SP that accepts the user ID and password as inputs, checks whether they match a valid logon, and returns the member first name+lastname and cookie value. The name should be returned as a single text string containing the first and last name. The head developer wants the number of parameters minimized so that the same parameter is used to accept the password and return the name value. (passwd Paramater as IN OUT use passwd as INPUT firstname||lastname as OUTPUT) Also, if the user doesn’t enter a valid username and password, return the value INVALID in a parameter named p_check. Test the procedure using a valid logon first, with the username rat55 and password kile. Then try it with an invalid logon by changing the…
Try to complete the tasks below. Create a MYSQL Database named ' db' Create a MYSQL User named 'dbuser' with a password 'dbpass' Grant Insert, Delete, Update and Select privileges for ' dbuser' on 'db' Create a MYSQL Table on database 'db' and name it as 'students' with the following field and field properties Field Name Field Type Field Size Additional Information Student No Varchar Name 6 Primary key Varchar Varchar 20 25 Surname birthdate date Using Mysqli Commands (not the pdo): A University wants to record their students with the following properties in order to give chance to the teachers to make a search: Students should be recorded with the following fields.: Student No, Name, Surname, birthdate. and a mysql You must create 3 forms ( 1 html for menu and 2 php) table (which has the above fields). 1. Menu as html which will have link to other files.Snippng Tool 2. A Form to add a new student into db table. 3. A form to search a student. Search could be made via using any of the…