Answered: First, create (Clone) another version…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

First, create (Clone) another version of DEPARTMENTS table with Create table as select command .something like this below.

CREATE TABLE new_departments AS SELECT * FROM hr_DEPARTMENTS WHERE 1=2;

This unmatcheched WHERE condition will be able to create same table as DEPARTMENT but no data in it. Empty version.

Create a PL/SQL block that selects the record which belongs to maximum department ID in the hr_departments table and stores entire record info to composite variable as RECORD. (Lets say cv_dept)

Create this composite variable same ROWTYPE of DEPARTMENT table.

Declare a variable, v_max_deptno , of type NUMBER in the declarative section.

Start the executable section with the BEGIN keyword and include a SELECT statement to retrevive the maximum department_id from the departments table.
By using this v_max_deptno use this number in WHERE condition of SELECT statement and make sure you only bring one row from DEPARTMENTS table to composite variable.
You will now INSERT this max department number record info to newly created table new_departments table
To do that you will use RECORD feature; INSERT INTO new_departments VALUES cv_dept ;

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions