Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 2) 1 Run the following SQL statement to create a new table for inserting and storing the employees' jobs. CREATE TABLE new jobs AS

image text in transcribed
QUESTION 2) 1 Run the following SQL statement to create a new table for inserting and storing the employees' jobs. CREATE TABLE new jobs AS (SELECT * FROM HR.JOBS); Define the ADD JOB procedure which will insert a new job into the NEW_JOBS table. The procedure takes two parameters, the Job ID and the Job Title. Invoke (call) the procedure twice, one with passing MGR' as job ID and 'MANAGER' as a job title, and the second time by passing 'DBA' as a job ID and DATABASE ADMINISTRATOR' as a job title. Test the new table NEW_JOBS to check that the procedure is working probably

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions

Question

Be familiar with the basic ways to manage capacity.

Answered: 1 week ago

Question

Be familiar with the five basic ways to manage demand.

Answered: 1 week ago