Create Procedure in (PL/SQL) called Make_Account (v_first, v_last, v_email, v_errormsg) Add a new user to the...

Create Procedure in (PL/SQL)

called Make_Account (v_first, v_last, v_email, v_errormsg)

Add a new user to the Account table. If the new user cannot be added, return a error message.

Table Account (this is the table I need to add data using PROCEDURE)

Account_no (PK)

Email (VARCHAR2)

first (VARCHAR2)

last (VARCHAR2)

Expert Solution

Table created usiing identity as your question specified to insert except account number as Make_Account (v_first, v_last, v_email, v_errormsg)

Note : Stored proecduere created. But your question says to insert v_errormsg in call (Make_Account (v_first, v_last, v_email, v_errormsg)) I can not understand the logic behind it passing v_errormsg . how we know the error before insert as user who inserts value . Anyway i did as you reqqueted but i display the oracle's SQLERRM when error occurs.

successful insert showing procedure code ouptut

Failed insert ouptut as i mssed one parameter to demonstrate how error handling works

I used value_error for example . You can use others in exception

venereology answered 1 year ago

PL/SQL Write a PL/SQL block, using a While Loop, to calculate and print the sum of...

PL/SQL Write a PL/SQL block, using a While Loop, to calculate and print the sum of the odd integers from 10 to 120 inclusive. (Hint: 11 + 13 + 15 + . . . + 97 + 99)

PL/SQL Write a PL/SQL block, using a Case Statement that prints a student’s letter grade...

PL/SQL Write a PL/SQL block, using a Case Statement that prints a student’s letter grade based on the value stored in a variable called grade. Use the ACC grading system described in the course syllabus to create the block and set the initial value of grade as 95. Use only one print statement and no logical operators in your code. Assume a grade can exceed 100, but it can’t be negative. Grade Scale: Grade Scale:...

Assignment 2- 9 USING A FOR LOOP Create a PL/SQL block using a FOR loop to...

Assignment 2- 9 USING A FOR LOOP Create a PL/SQL block using a FOR loop to generate a payment schedule for a donor’s pledge, which is to be paid monthly in equal increments. The values variable for the block is starting payment due date, monthly payment amount, and a number of total monthly payments for the pledge. The list that’s generated should display a line for each monthly payment showing payment number, date due, payment amount, and donation balance (remaining...

Using SQL create a new database called school_app. Create a student table with fields id (auto...

Using SQL create a new database called school_app. Create a student table with fields id (auto increment), first_name, last_name. Create a course table with fields id (auto increment), course code (such as ITC or MTH), and course number (such as 100 or 295). Note that the relationship between student and course is many-to-many (n:m). Create a join table called student_course that implements the n:m relationship with fields id (auto increment), student_id, course_id, and grade (which has values 0, 1, 2,...

ORACLE TASK 2-2 USING A FOR LOOP Create a PL/SQL block using a FOR loop to...

ORACLE TASK 2-2 USING A FOR LOOP Create a PL/SQL block using a FOR loop to generate a payment schedule for a donor’s pledge, which is to be paid monthly in equal increments. Values variable for the block are starting payment due date, monthly payment amount and number of total monthly payments for the pledge. The list that’s generated should display a line for each monthly payment showing payment number, date due, payment amount, and donation balance (remaining amount of...

Utilize the Outdoor Clubs & Product database to create a PL/SQL anonymous block program unit that...

Utilize the Outdoor Clubs & Product database to create a PL/SQL anonymous block program unit that lists the product_name attribute value and a demand status text display. The demand status text display is determined by counting the number of times a product has been ordered so far. The demand status text display will be either “Low Demand” or “High Demand”. Low Demand is displayed if the product has been ordered less than 2 times. High Demand is displayed if the...

Create a PL/SQL anonymous block that uses a nested loop (inner loop 1 to 15; outer...

Create a PL/SQL anonymous block that uses a nested loop (inner loop 1 to 15; outer loop 1 to 5) to perform computations using the SQL functions, ABS, EXP, SQRT, ROUND, MIN, MAX, LOG, MOD, REMAINDER and POWER The outer loop will use the functions, ABS, EXP, SQRT, ROUND to display the following messages (must be “ The absolute value of <outer loop index> is <value>” “ The value of e to the <outer loop index> power is <value>” “...

Create a new SQL Developer SQL worksheet and create/run the following TWO (2) queries and save...

Create a new SQL Developer SQL worksheet and create/run the following TWO (2) queries and save your file as Comp2138LabTest1_JohnSmith100123456.sql (replace JohnSmith 100123456 with your name and student ID). Please place comment that includes your name and your student ID at the top of your script and number your queries using comments sections. Each query carries equal weight. A selection of the expected result set has been shown below for your convenience. Your output should match with this sample output....

Create a stored procedure that can be used to add a student to the school and...

Create a stored procedure that can be used to add a student to the school and a section of a course. 1. If the student already exists, then just add him to the section (do not update information like address). 2. The procedure will require the following arguments (see table definition for types): A. Salutation B. First Name C. Last Name D. Street Address (including City) E. ZIP Code F. Phone Number G. Employer Name (if any) H. Course Number...

Developer User Account Create a user account using T-SQL for developers named DEVELOPER with the password...

Developer User Account Create a user account using T-SQL for developers named DEVELOPER with the password TESTACCOUNT that grants the user the ability to: Select and modify any table. Connect to and have access to all resources. In SSMS

Question