Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me solve this Write a PL/SQL stored procedure to insert a row in the employees table. Use %type to declare each variable of
Please help me solve this
Write a PL/SQL stored procedure to insert a row in the "employees" table. Use %type to declare each variable of correct/compatible type, matching each column of employee table.
The procedure call must send the value to each column at the run time.
DEPARTMENTS * DEPARTMENT_ID * DEPARTMENT_NAME MANAGER_ID LOCATION_ID P LOCATIONS LOCATION_ID STREET_ADDRESS POSTAL_CODE F F F * CITY * JOB_HISTORY PF * EMPLOYEE_ID P START_DATE * END_DATE F* JOB_ID F DEPARTMENT_ID STATE_PROVINCE COUNTRY_ID F EMPLOYEES P * EMPLOYEE_ID FIRST_NAME * LAST_NAME U * EMAIL PHONE_NUMBER HIRE_DATE F* JOB_ID SALARY COMMISSION_PCT F MANAGER_ID F DEPARTMENT_ID V COUNTRIES P * COUNTRY_ID COUNTRY_NAME F REGION_ID V JOBS * JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY REGIONS P * REGION_ID REGION_NAME
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