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.
Oracle SQL • Create a function that sums two numbers if any of the two numbers ins larger than 10 , otherwise it will multiplies the two numbers • Create a stored procedure that inserts into myemployees table a row, the values must be passed as arguments to the procedure. • Create a trigger on MyEmployees table that will do the following on the insert Add 100 to the inserted salary if the salary is more than 5000 Subtract 150 from the inserted salary if the salary is less than or equal to 5000 Note: MyEmployees table is a copy of hr.employees table. You can create it using the following statement CREATE TABLE MyEmployees AS SELECT * FROM hr.Employees
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.
QUESTION 8 Which of the following is not true about the PL/SQL functions? O A It is similar to the PL/SQL procedure except that it returns a value. O B. The RETURN clause doesn't specify the data type of the return value OC.Can be invoked only from within stored procedures or triggers. D. The function must contain a return statement.
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`);
PL/SQL Display the first name and salary*10000 of all employees who works for department 50. Handle exceptions like Invalid cursor, cursor already open and no data found. Multi Line Text.
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.…