Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pl/sql please step by step 6:22 Done Exercise 4 -6_22dff22794e3... Exercise 4 Instruction: Include FULL Screenshot that display your code and output on SQL Developer

pl/sql
please step by step
image text in transcribed
6:22 Done Exercise 4 -6_22dff22794e3... Exercise 4 Instruction: Include FULL Screenshot that display your code and output on SQL 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 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 Number less the Second Number". Note: you need to include all the three conditions statements Exercise 6 Instruction: Include FULL Screenshot that display your code and output on SQL Developer 1) Execute the following SOL: 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

DB2 Universal Database V7.1 Application Development Certification Guide

Authors: Steve Sanyal, David Martineau, Kevin Gashyna, Michael Kyprianou

1st Edition

0130913677, 978-0130913678

More Books

Students also viewed these Databases questions

Question

3. Job rotation is used for all levels and types of employees.

Answered: 1 week ago