Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

VIEW Sea to the PL sign Layout References Mailings Review View Help the Internet can contain viruses. Unless you need to edit, it's safer to

image text in transcribed
image text in transcribed
VIEW Sea to the PL sign Layout References Mailings Review View Help the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Exercise 4 (1%) Instruction: Include Full Screenshot that display your code and output on sol. Developer or Live SQL .Write PL/SQL block that will insert new department id in the department table in HR database as following: Department_id = 290 and Department_name"Information Technology. Write select statement to show the inserted row. Department_id = 300 and Department_name='Procurement". Write select statement to show the inserted row. Exercise 5 (1%) 1) Write PU/SQL block that will display the highest and lowest employee salary in department_id 60. 2) Write PU/Sublock that will increase the minimum salary of an employee by 10% Exrcise 6 (1%) Instruction: Include FULL Screenshot that display your code and output on SQL Developer Create PL/SQL block that has two variables of number datatype, assign numerical values to the two variables, then compare these two numbers, if the first number greater than the second number display the message First Number is greater than Second Number if the two numbers are equal display "Two numbers are equal", lastly, if the first number less than second number, display first Numberless the Second Number Note: you need to include all the three conditions statements Exercise 4-7 (2) - Protected ViewSaved to this PC. Layout References Mailings Review View Help can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Exercise 7(1 %) Instructions include FUL Screenshot that display your code and output on SQL Developer 1) Execute the following SQL: DROP TABLE mails; CREATE TABLE mails (inbox number); 2) Write a PL/SQL block to insert numbers into the mails table. a) Insert the numbers 5 through 15, excluding 7 and 9. b) Commit before the end of the block. c) Execute a SELECT statement to verify that your PL/SQL block worked

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

Medical Image Databases

Authors: Stephen T.C. Wong

1st Edition

1461375398, 978-1461375395

More Books

Students also viewed these Databases questions

Question

4. What will the team agreement contain?

Answered: 1 week ago

Question

What were the issues and solutions proposed by each team?

Answered: 1 week ago