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

 1.Instruction: Include FULL Screenshot that display your code and output on

1.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 Dame='Information Technology. Write select statement to show the inserted row. Department.id = 300 and Department.pame='Procurement'. Write select statement to show the inserted row. 2.Instruction: Include FULL Screenshot that display your code and output on SQL Developer Create PUISQL 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 3.Instruction: Include FULL 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

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!