Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Create and invoke the GET_JOB finction to retum a jób title. a. Create and compile a function called GET_JOB to retum a job title. b. Create a VARCHAR2 host variable called b_title, allowing a length of 35 characters. Invoke the function with the SA_REP job ID to retum the value in the host variable, and then print the host variable to view the result. anonyaous block coapleted b_title Sales Representative 2. Create a function called GET_ANNUAL_COMP to retum the annual salary computed from an employee's monthly salary and commission passed as parameters. a. Create the GET_ANNUAL_COMP fiunction, which accepts parameter values for the monthly salary and commission. Either or both values passed can be NULL, but the function should still return a non-NULL anual salary. Use the following basic fomula to calculate the annual salary: dreamstm Oras (salary*12) + (commission_pct*salary*12) b. Use the function in a SELECT statement against the EMPLOYBES table employees in department 30. LOTEE_ID LAST_KAE 114 Papheely 132000 7200 116 Baide 34500 Tabias 33600 118 119 Hiro 31200 Colaenares 30000 6 coua selected 3. Create a procedure, ADD_EMPLOYEE, to insert a new employee into the EMPLOYEES table. The procedure should call a VALID_DEPTID function to check whether the department ID specified for the new employee exists in the DEPARTMENTS table. a. Create a function called VALID_DEPTID to validate a specified department ID and retum a BOOLEAN value of TRUE if the department exists.

Create and invoke the GET_JOB finction to retum a jób title. a. Create and compile a function called GET_JOB to retum a job title. b. Create a VARCHAR2 host variable called b_title, allowing a length of 35 characters. Invoke the function with the SA_REP job ID to retum the value in the host variable, and then print the host variable to view the result. anonyaous block coapleted b_title Sales Representative 2. Create a function called GET_ANNUAL_COMP to retum the annual salary computed from an employee's monthly salary and commission passed as parameters. a. Create the GET_ANNUAL_COMP fiunction, which accepts parameter values for the monthly salary and commission. Either or both values passed can be NULL, but the function should still return a non-NULL anual salary. Use the following basic fomula to calculate the annual salary: dreamstm Oras (salary*12) + (commission_pct*salary*12) b. Use the function in a SELECT statement against the EMPLOYBES table employees in department 30. LOTEE_ID LAST_KAE 114 Papheely 132000 7200 116 Baide 34500 Tabias 33600 118 119 Hiro 31200 Colaenares 30000 6 coua selected 3. Create a procedure, ADD_EMPLOYEE, to insert a new employee into the EMPLOYEES table. The procedure should call a VALID_DEPTID function to check whether the department ID specified for the new employee exists in the DEPARTMENTS table. a. Create a function called VALID_DEPTID to validate a specified department ID and retum a BOOLEAN value of TRUE if the department exists.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
100%

use the sql to answer the following question as picture shown

1. Čreate and invoke the GET_JOB function to return a job title. a. Create and compile a function called GET_JOB to return a job title. b. Create a VARCHAR2 host variable called b_title, allowing a length of 35 characters. Invoke the function with the SA_REPjob ID to retun the value in the host variable, and then print the host variable to view the result. DResuts Scrigt Outpue YEplan Autotrace ROEMS OLtput QoWA Output| anonymous block completed b_title Sales Representative 2. Create a function called GET_ANNUAL_COMP to retum the annual salary computed from an employee's monthly salary and commission passed as parameters. a. Create the GET_ANNUAL_COMP function, which accepts parameter values for the monthly salary and commission. Either or both values passed can be NULL, but the function should still retum a non-NULL anual salary. Use the following basic fommula to calculate the annual salary: (salary*12) + (commission_pct*salary*12) b. Use the function in a SELECT statement against the EMPLOYBES table employees in department 30. dreasm EMPLOYEE_ID LAST_KAME Annual Cosper 114 115 116 117 116 Raphsely 132000 Khoo 37200 Baida 34800 Tabias 33600 Himuro 31200 & Ora 119 Colaenares 30000 6 EOua selected 3. Create a procedure, ADD_EMPLOYEE, to insert a new employee into the EMPLOYEES table. The procedure should call a VALID_DEPTID function to check whether the department ID specified for the new employee exists in the DEPARTMENTS table. a. Create a function called VALID_DEPTID to validate a specified department ID and retum a BOOLEAN value of TRUE if the department exists.
Transcribed Image Text:1. Čreate and invoke the GET_JOB function to return a job title. a. Create and compile a function called GET_JOB to return a job title. b. Create a VARCHAR2 host variable called b_title, allowing a length of 35 characters. Invoke the function with the SA_REPjob ID to retun the value in the host variable, and then print the host variable to view the result. DResuts Scrigt Outpue YEplan Autotrace ROEMS OLtput QoWA Output| anonymous block completed b_title Sales Representative 2. Create a function called GET_ANNUAL_COMP to retum the annual salary computed from an employee's monthly salary and commission passed as parameters. a. Create the GET_ANNUAL_COMP function, which accepts parameter values for the monthly salary and commission. Either or both values passed can be NULL, but the function should still retum a non-NULL anual salary. Use the following basic fommula to calculate the annual salary: (salary*12) + (commission_pct*salary*12) b. Use the function in a SELECT statement against the EMPLOYBES table employees in department 30. dreasm EMPLOYEE_ID LAST_KAME Annual Cosper 114 115 116 117 116 Raphsely 132000 Khoo 37200 Baida 34800 Tabias 33600 Himuro 31200 & Ora 119 Colaenares 30000 6 EOua selected 3. Create a procedure, ADD_EMPLOYEE, to insert a new employee into the EMPLOYEES table. The procedure should call a VALID_DEPTID function to check whether the department ID specified for the new employee exists in the DEPARTMENTS table. a. Create a function called VALID_DEPTID to validate a specified department ID and retum a BOOLEAN value of TRUE if the department exists.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS