Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Alter the given table by adding new column of Job in it and assign the sequence values to the column AS WELL EMPLOYEE_ID LST_NAME
2. Alter the given table by adding new column of Job in it and assign the sequence values to the column AS WELL
EMPLOYEE_ID LST_NAME ANNSAL HIRE_DATE
149 Zlotkey 126000 29-JAN-00
174 Abel 132000 11-MAY-96
176 Taylor 103200 24-MAR-96
. NOTE: ASSUME 100 RECORDS IN THE TABLE. YOU NEED TO CREATE PROCEDURE FOR IT. USE ANY LOOP TO FILL THE ENTERIES ALONG WITH DML OPERATION.
NOTE: please deliver correct answer if you don't know then ignore
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