Question: 1. CREATE TABLE DBUSER( USER ID USERNAME AGE STATE PRIMARY KEY USER_ID) NUMBER (5) NOT NULL, VARCHAR2 (20) NOT NULL, NUMBER (3) NOT NULL VACHA

1. CREATE TABLE DBUSER( USER ID USERNAME AGE STATE PRIMARY KEY

1. CREATE TABLE DBUSER( USER ID USERNAME AGE STATE PRIMARY KEY USER_ID) NUMBER (5) NOT NULL, VARCHAR2 (20) NOT NULL, NUMBER (3) NOT NULL VACHA R2 (20) Insert at least 5 rows. Write the following procedures inlPLSQL. Please take snapslhots showing that your code works. 3. Add a new user: Get the following details from the user: UserID, Username, Age and State and insert a new row. 4. Delete an existing user: Get the UserID from the user and delete the row. 5. Search for a username based on user id Hint: Use Implicit Cursor): Get the id from the user and output the name 6. List usernames based on a given state (Hint: Use Explicit Cursor): Get the state from the user and output the list of usernames from that state. (NOTE: Please make sure that there are atleast 2 users from each state)

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!

HERE IS THE TINY VIDEO SCHEMA FOR MYSQL WORKBENCH /* Database Systems, 9th Ed., Coronel/MOrris/Rob */ /* Type of SQL : MySQL */ CREATE SCHEMA IF NOT EXISTS TINY_VIDEO; USE TINY_VIDEO; DROP TABLE IF...

Using MySQL Workbench SELECT commands answer the questions listed below using the Tiny Video schema used in your previous assignment. Submit via the D2L drop box the final SQL script for each...

1.What is relationships do Steven Kings dependents have with them? 2.How many dependents are in Canada? 3. How many dependents are in Seattle? 4.How many employees do not have children? 5. Which...

DATABASE SQL PLUS Lab Exercises First: - Create the following tables: 1. CREATE TABLE cards ( card_id number (10) primary key NOT NULL, status number (3) NOT NULL, created_at date NOT NULL,...

Starter Text File: create table Worker ( WID number (9) Constraint pk_Wkr primary key, First_Name varchar2 (30) constraint nn_FN not null, Last_Name varchar2 (30) constraint nn_LN not null, MI...

TABLES FOR THE ASSIGNMENT CREATE TABLE CustomerService.Reps ( RepID int IDENTITY(1,1), CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID), BusinessEntityID int not null, CONSTRAINT FK_BusinessEntityID...

1. Consider the following code: DECLARE a number; b number; c number; BEGIN a:= 23; b:= 45; findMin(a, b, c); dbms_output.put_line(' Minimum of (23, 45) : ' || c); END; Write the following procedure:...

I need help with this lab to complete assignment. This requires MySQL Workbench. I did step 1 , need help with remaining steps. Next, we will create a table in order to help us keep track of...

In Oracle, Generate ERD Diagram for Dreamhome and Paste results in this format/Style CREATE TABLE branch ( branchno char(5) NOT NULL, street varchar(35) DEFAULT NULL, city varchar(10) DEFAULT NULL,...

What is the Laffer Curve? How do supply-siders use it with respect to tax rates?

Why was the Sarbanes-Oxley legislation passed in 2002, and what are its implications for the accounting profession?

A(n) -- plan is designed to address how the organization will fund its operations and strategic programs

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Question What is the advantage of a voluntary DBO plan?

Question How is life insurance used in a DBO plan?

Question Do the Section 79 nondiscrimination rules require, in effect, that the plan must cover practically all employees of an employer and provide all of them with insurance equal to the same...