CIS250 Unit 2 Assignment 2 Directions Perform the tasks below by using the corre
ID: 3622219 • Letter: C
Question
CIS250 Unit 2 Assignment 2Directions
Perform the tasks below by using the correct SQL statements. You must create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-free, copy and paste your statements into the assignment document. Upload this Word document for grading.
Scenario:
The suppliers want access to our database to enter their own prices. Although they are worried that other suppliers can see their prices, we have assured them that this is not possible.
Complete the following by creating the appropriate SQL statements:
2. Use the data dictionary to get the SELECT statement for the view you just created. Write that SELECT statement below (DO NOT Test this statement in Oracle):
Explanation / Answer
Dear, Create or Replace view l_employee1_view as Select EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DEPT_CODE, HIRE_DATE, CREDIT_LIMIT, PHONE_NUMBER, MANAGER_ID From l_employee ----------------------------------------------------------------- Select statement Select EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DEPT_CODE, HIRE_DATE, CREDIT_LIMIT, PHONE_NUMBER, MANAGER_ID From l_employee