Question: Write a script that uses the information on the Oracle emp table. I want you to use the for cursor loop. I want the cursor

Write a script that uses the information on the Oracle emp table. I want you to use the for cursor loop. I want the cursor to only contain records where the deptno is less than 25 . The processing is to give a 10% bonus to employees making less than 3000 and give a 12% bonus to other employees. I want you to display the empno deptno and bonus. (Ctrl)

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 Programming Questions!

C++ Very Important to Read: For program 2 you will be using a string class to read from a file, sort and then output some string . I will give you most of the code for the string class called...

PROMPT: During the workplace investigation interviews, you will be interviewing 6 witnesses. Outline a list of questions or topics you want to ask each witness. You may format your outline in a...

The town of Eden Bay owns and maintains a feet of vehicles. You are a systems analyst reporting to Dawn, the town's IT manager. Background Eden Bay is a medium-sized municipality. The town has grown...

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) );...

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Create a file named YourLastName_A.BAT . This file will give the user a choice to compile or run your stored procedures. Your file should do the following: Prompt the user to Compile or Run (user...

oracle sql statement help. I will upvote a clear, detailed response. Thank you!! more joins (inner and outer), subqueries and other SQL issues You are suggested to adopt a user friendly prefix string...

Project 2 was a logical model of the Mom & Pop database. Step One: CREATE THE SQL DDL FOR YOUR DATABASE For your logical database model created in Project 2 , create the SQL DDL commands that will be...

A 12.0-kg bucket is lowered vertically by a rope in which there is 163 N of tension at a given instant. What is the acceleration of the bucket? Is it up or down?

which the discount will apply will increase from 70% to 80%. The company sells only one product for which there is an annual demand of 96 000 units. The purchase price of the and she approached the...

t = 3 , and t = 4 ? v ( 2 ) = , f t s e c v ( 3 ) = , t s e c v ( 4 ) = , f t s e c A t what time ( i n seconds ) does the object reach its maximum height? ( R o u n d your answer t o one decimal...

Zero Corporation contributes inventory (computers) to State University for use in its mathematics program. The computers have a $1,225 cost basis and an $2,800 FMV. How much is Zeros charitable...

A five-year bond with a yield of 11% (continuously compounded) pays an 8% coupon at the end of each year. a) What is the bonds price? b) What is the bonds duration? c) Use the duration to calculate...

Carver Corporation uses the accrual method of accounting and the calendar year as its tax year. Its board of directors authorizes a cash contribution on November 3 of Year 1, that the corporation...

Heritage Gardens provides complete garden design and landscaping services. The company uses a job-order costing system to track the costs of its landscaping projects. The table below provides data...

Three funds of the Leukemia Foundation, a nonprofit welfare organization, began an investment pool on January 1, 2013. The costs and fair market values on this date were as follows: During 2013 the...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

62. Consider the particle from Exercise 57. What is the expected number of steps the particle takes to return to the starting position? What is the probability that all other positions are visited...

63. For the Markov chain with states 1, 2, 3, 4 whose transition probability matrix P is as specified below find fi3 and si3 for i = 1, 2, 3. 0.4 0.2 0.1 0.3] 0.1 0.5 0.2 0.2 P = 0.3 0.4 0.2 0.1 0 0...

61. Suppose in the gamblers ruin problem that the probability of winning a bet depends on the gamblers present fortune. Specifically, suppose that i is the probability that the gambler wins a bet...