Answered step by step
Verified Expert Solution
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
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 please step by step
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started