Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

QUESTION 1) Run the following SQL statement to create a new table for inserting and storing the employees' salaries. Run the following statement to create CREATE TABLE TOP_SALARIES (salary NUMBER...

MySQL Databasing, Schema name "rentalcompany" The database is over 3mb, but this is a little bit more info, all I need is the "directions" part of it. 1. Download RentalCompany.sql from Doc Sharing...

DDL STATEMENTS This lab is designed to practice the create command of DDL statement. - 1. Write a SQL statement to create a simple table countries including columns country_id, country.name and...

First create a practice database, then add 2 new tables, customers and orders, each table should have primary keys auto - increments defined. Then, answer each question below by providing a...

. EPU kareena Connections 2 Y 12 Com Tables (Filtered) A_EMPLOYEES ADVISOR CONTACTS COUNTRIES CUSTOMERS EMPLOYEES INVENTORIES LOCATIONS schema.sal data(1).salx 50L BTM210_L04_Talreja.sql.pdf.salx...

Topics: Creating tables with primary keys Creating related tables with appropriate foreign keys (1:M, M:N relationships) Inserting data Updating data Selecting data (using logical operators, date...

MIcrosoft SQl server. Answer correctly - dont spam Share screenshot Customer Table: CREATE TABLE CUSTOMER ( CID int PRIMARY KEY, ENAME varchar (30) not null, Name varchar (30), Address varchar (50)...

Preliminary work for this Project 1 . Use the CREATE and SELECT SQL statements to Create a Temporary table as a full copy ( all rows & columns ) of the table ORDERS. Name the new table ORDERS _ COPY....

Before you do the exercises If you havent already done so, you should create a folder in your personal drive for all the exercises. This set of exercises requires a functioning webserver to interpret...

please solve this in sql asap .thank you Tasks: Add SET AUTOCOMMIT ON; under the comment header and execute it. Consider the following table specifications: Remember to comment the question number...

Write a paper on Can We Be Good without God?

The beam cross section below has a shear force of S, applied at the shear centre (SC). This produces sectional shear forces of Q1 and Q2 as indicated (both above and below the mid-line). Note the...

q , are the total sum an employer pays their employee for work done.

help please !! Brief Exercise 14-19 On January 1, 2020, Marin Incorporated redeemed bonds prior to their maturity date of January 1, 2021. The face value of the bonds was $490,000, and the redemption...

Be familiar with the basic ways to manage capacity.

Describe the building blocks of dealing with the problem of fluctuating demand.

Be familiar with the five basic ways to manage demand.