Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 4 4 Points 1. Create the following table employees. ID 1 2 3 4 5 6 NAME Rashed Khadeeja Fouad Saeed Nada Kamal AGE

image text in transcribed

Question 4 4 Points 1. Create the following table employees. ID 1 2 3 4 5 6 NAME Rashed Khadeeja Fouad Saeed Nada Kamal AGE 32 25 23 25 27 22 ADDRESS SALARY Dubai 2000.00 Dubai 1500.00 Abu Dhabi 2000.00 Sharjah 6500.00 Dubai 8500.00 Al Ain 4500.00 Create a procedure that: 1. Increase the employees' salary by500. 2. Declares a cursor to include employee's ID, name, and salary. 3. Declare three variables eid, ename, salary with the same datatype as their counterpart in the table employees. 4. For each row of the cursor, assign the values of the cursor to the variables you declared above and print them to the screen. Question 4 4 Points 1. Create the following table employees. ID 1 2 3 4 5 6 NAME Rashed Khadeeja Fouad Saeed Nada Kamal AGE 32 25 23 25 27 22 ADDRESS SALARY Dubai 2000.00 Dubai 1500.00 Abu Dhabi 2000.00 Sharjah 6500.00 Dubai 8500.00 Al Ain 4500.00 Create a procedure that: 1. Increase the employees' salary by500. 2. Declares a cursor to include employee's ID, name, and salary. 3. Declare three variables eid, ename, salary with the same datatype as their counterpart in the table employees. 4. For each row of the cursor, assign the values of the cursor to the variables you declared above and print them to the screen

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_2

Step: 3

blur-text-image_3

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

Put Your Data To Work 52 Tips And Techniques For Effectively Managing Your Database

Authors: Wes Trochlil

1st Edition

0880343079, 978-0880343077

More Books

Students also viewed these Databases questions