Write a PL/SQL stored procedure to print number of employees who are working in a job with Title "Tester". Include procedure call also.If the total count of Employees is more than 5 then print "Sufficient number of Employees"If the total count of Employees is less than 5 then print "Insufficient number of Employees"Else print "there are 5 employees".Use Oracle's NO DATA_FOUND build in exception to display the last message.DEPARTMENTSLOCATIONSP DEPARTMENT_ID* DEPARTMENT_NAMEMANAGER_IDLOCATION_IDP LOCATION_IDSTREET ADDRESSPOSTAL_CODE* CITYSTATE PROVINCECOUNTRY_IDJOB_HISTORYPF* EMPLOYEE_IDP * START DATE* END DATEF JOB IDFDEPARTMENT_IDEMPLOYEESP EMPLOYEE_IDFIRST NAME* LAST_NAMEEMAILCOUNTRIESCOUNTRY_IDCOUNTRY_NAMEFREGION IDPHONE_NUMBER* HIRE DATEF JOB_IDJOBSP JOB_ID* JOB_TITLEMIN_SALARYMAX_SALARYSALARYCOMMISSION_PCTMANAGER_IDFREGIONSDEPARTMENT_IDP* REGION_IDREGION_NAMEI--

create procedure Tester as Select count(*) case when count(*) >5 then print 'Sufficient number…

Write a PL/SQL stored procedure to print number of employees who are working in a job with Title "Tester". Include procedure call also. If the total count of Employees is more than 5 then print "Sufficient number of Employees" If the total count of Employees is less than 5 then print "Insufficient number of Employees" Else print "there are 5 employees". Use Oracle's NO DATA_FOUND build in exception to display the last message.

Write a PL/SQL stored procedure to print number of employees who are working in a job with Title "Tester". Include procedure call also. If the total count of Employees is more than 5 then print "Sufficient number of Employees" If the total count of Employees is less than 5 then print "Insufficient number of Employees" Else print "there are 5 employees". Use Oracle's NO DATA_FOUND build in exception to display the last message.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

//stored procedure create or replace procedure firstthree (my_seqid in varchar2) as cursor c1 is select sname, grade from student s join taken t on s.sid=t.sid where seqid=my_seqid order by grade desc; -- my_sname varchar2(40); my_sname student.sname%TYPE; -- my_grade number(2,1); my_grade taken.grade%TYPE; begin /* clear the my_tmp table */ delete from my_tmp; commit; open c1; for i in 1..3 loop fetch c1 into my_sname, my_grade; exit when c1%notfound; /* in case the number requested */ /* is more than the total */ /* number of enrolled students */ /* display the result */ dbms_output.put_line('name: ' || my_sname || ' ' || 'grade: ' || my_grade); /* put into temporary table */ insert into my_tmp values(my_sname, my_grade); commit; end loop; close c1; end; / -------------- //php <? $connection = oci_connect ("test", "test", "test"); if ($connection == false){ $e = oci_error();…
I need to create a PL/SQL program that prompts the user for a number. This number will be the top(cap) number. This program will find all the even and odd numbers between 1 to this max number. The program should continue to find odd and even numbers from 1 to the maximum number given (entered) by the user. If user input is less than or equal to zero Program should not even start doing its task and right away print ‘Sorry I can not calculate odd and even numbers for negative or zero’. But when user entered any positive number then the program should display all numbers as either even or odd. Here is the example; Assume user entered 12. This will be cap number From 1 to 12 all the numbers in between your program will be finding out each of the number either as odd or even 1 is odd number 2 is even number 3 is odd number 4 is even number 5 is odd number 6 is even number 7 is odd number 8 is even number 9 is odd number 10 is even number 11 is odd number 12 is even number Thank you in…
Task 8: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in I_INVOICE_NUM to the date currently found in I_INVOICE_DATE.
please use sql to answer the following question an erd has been add a) Add a new row in the ORDERS table with the following data: Order# = 1021, Customer# 1009, and Order date = today’s date. Modify the zip code on order 1017 to 33222. Save the changes permanently to the database. Apply commit Add a new row in the ORDERS table with the following data: Order# = 1022, Customer# =2000, and Order date = today’s date. Describe the error raised and what caused the error.
Go through the CRUD operations supported by the SQLiteOpenHelper and SQLiteCursor classes.
Do this in MySQL please: Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The INV_SUBTOTAL is the sum of the LINE_TOTAL amounts for the invoice, the INV_TAX is the product of the INV_SUBTOTAL and the tax rate (8 percent), and the INV_TOTAL is the sum of the INV_SUBTOTAL and the INV_TAX.
Imagine that you are a database manager at a company that makes custom shirts. One column in the database lists the wholesale price of the shirts. A second column lists the labor charge, which is currently set to 11 percent of the wholesale price of the shirt. A third column lists the retail price of the shirt, which is the combination of the wholesale price and the labor charge. Write the statements that calculate the values that belongs in the second and third columns. How could you use a query to format these columns?
PLZ help urgent: change the following so it works on oracle sql live or oracle sql developper CREATE TABLE `book`( `num` INT(20) NOT NULL AUTO_INCREMENT, `title` VARCHAR(20), `year` DATE, `subject` VARCHAR(20), `checkedout` DATETIME, `checkedin` DATETIME, PRIMARY KEY (`num`) ); CREATE TABLE `client`( `CID` INT(20) NOT NULL AUTO_INCREMENT, `fname` VARCHAR(25), `lname` VARCHAR(25), `type` VARCHAR(25), `num` INT(20), PRIMARY KEY (`CID`), FOREIGN KEY (`num`) REFERENCES `emp`.`state`(`state_id`) ); CREATE TABLE `author`( `id` INT(10) NOT NULL AUTO_INCREMENT, `year` DATE, `fName` VARCHAR(20), `lname` VARCHAR(20), `num` INT(20), PRIMARY KEY (`id`) ); ALTER TABLE `author` ADD FOREIGN KEY (`num`) REFERENCES `book`(`num`); ALTER TABLE `client` ADD CONSTRAINT `client_ibfk_1` FOREIGN KEY (`num`) REFERENCES `book`(`num`);
In this assignment, we use the same database that you have been using for the labs and the assignment 1. Note: For each query in your assignment, make sure you handle the errors and display the proper message including the error code and the error message. try{ ... } catch (SQLException& sqlExcp) { cout createConnection(user, pass, constr); Remember to terminate and close the connection and the environment when your program terminates. env->terminateConnection(conn); Environment::terminateEnvironment(env); After executing the statements make sure you terminate the statement. conn->terminateStatement(stmt); You will implement the following Oracle stored procedures and C++ functions: Stored Procedures find_customer (customer_id IN NUMBER, found OUT NUMBER); This procedure has an input parameter to receive the customer ID and an output parameter named found. This procedure looks for the given customer ID in the database. If the customer exists, it sets the variable found to 1.…
Write a script that creates and calls a stored procedure named spUpdateInstructor that updates the AnnualSalary column in the Instructors table. This procedure should have one parameter for the instructor ID and another for the annual salary. If the value for the AnnualSalary column is a negative number, the stored procedure should raise an error that indicates that the value for this column must be a positive number. Code at least two EXEC statements that test this procedure.
Which of the following is NOT true about PL/SQL constants? The CONSTANT declaration does not require data type. A constant contains a value that cannot be changed after being declared. A constant is declared using the CONSTANT keyword. A CONSTANT declaration must contain an initial valu
plz fix the following so it runs on sql developper or sql live CREATE TABLE DONORS (donor_id INT NOT NULL,donor_name varchar(255) NOT NULL,donor_age int,PRIMARY KEY (donor_id ),);CREATE TABLE DONATIONS(pledge_id INT NOT NULL,pledge_date varchar(255) NOT NULL,amount_pledged int,Is_paid int,donor_id int,PRIMARY KEY (pledge_id ),FOREIGN KEY (donor_id) REFERENCES DONORS(donor_id));