Question: please Apply PL/SQL to this database table. it has to include %ROWTYPE and CURSOR here is the SQL part in case necessary CREATE TABLE USERTABLE

please Apply PL/SQL to this database table. it has to include

please Apply PL/SQL to this database table. it has to include %ROWTYPE and CURSOR

here is the SQL part in case necessary

CREATE TABLE "USERTABLE" ( "USERID" NUMBER(10,0), "FIRSTNAME" VARCHAR2(60), "LASTNAME" VARCHAR2(60), "EMAIL" VARCHAR2(60), "PHONENUMBER" VARCHAR2(60), PRIMARY KEY ("USERID") ENABLE ) /

USERID FIRSTNAME LASTNAME EMAIL PHONENUMBER 1 Mohammed Namiq mohammednamiq@gmail.com 07721642165 2 Shan Bnar shanbnar@yahoo.com 07701553267 3 Miran Ahmad miranahmad@hotmail.com 07705246532 4 Lina Adnan linaadnan@yahoo.com 07701503232 5 Mirko kamal mirkokamal@yahoo.com 07503641287 Mohammed Baxtiar mohammedbaxtiar@hotmail.com 07721425787 7 Zhyar Baxtyar zhyarbaxtyar@gmail.com 07501553267 8 8 Miran Ahmad miranahmad@hotmail.com 07701402222 9 Miran Sherwan miransherwan@hotmail.com 07701503232 10 Bawan Hiwa bawanhiwa@yahoo.com 07501402222

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!

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

Oracle 11g PL/SQL question. The tables needed can be created with the c10_BBcreate.sql listed below. Using Dynamic SQL to create a procedure named add_row_sp for inserting a row into a table with...

DATABASE PROGRAMMING - WRITE THE SQL QUERIES FOR THE FOLLOWING QUESTIONS CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) );...

SQL Assignment. TIA SQL Table How to code subqueries Exercises 1. Write a SELECT statement that returns the same result set as this SELECT statement, but don't use a join. Instead, use a subquery in...

Can you please explain the code answers to me line by line with comments? I have the questions and answers but I am having trouble understanding everything that is going on. Thank you. This is in...

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

TASK You are to create a forum website based on the descriptions below, that allows users to sign up and create topics and posts on those topics. SET-UP Create a folder on...

please help using SQL plus or SQL Developer INSTRUCTOR: \ table [ [ INS _ ID , INS _ FNAME,INS _ SNAME,INS _ CONTACT,INS _ LEVEL ] , [ 1 0 1 , James,Willis, 0 8 4 3 5 6 9 8 5 1 , 7 ] , [ 1 0 2 ,...

Define heart

Laker Company uses the periodic inventory system. The table below summarizes details regarding the inventory at January 1, 2015; purchases invoices during the year; and the inventory count at...

The Primary Market is the:Atrading of exchange listed securities on that exchange floorBtrading of securities that are not exchange listed in the over - the - counter marketCtrading of exchange...

Bill and Joe decided to go on vacation together. Bill lives in Boston, and Joe lives in New York. They flip a coin to decide if they will fly from Boston or from New York, and then they flip a coin...

What is a labor union? Do you agree or disagree with its purpose? Defend your answer.

In your own words, define motivation. Discuss three ways managers can motivate employees.

Can workers be trained in ethics? How? Defend your answer.