Question: Write an anonymous PL/SQL block which checks the salary of the employee (id=120). if his salary is less than $2000, manager id of then employee

Write an anonymous PL/SQL block which checks the salary of the employee (id=120). if his salary is less than $2000, manager id of then employee is printed otherwise with "salary is high enough" is printed

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Heres an anonymous PLSQL block that checks the salary of an employee with ID 120 and prin... View full answer

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!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

PartA: Create a trigger that when work on record is added (namely, an employee works on a new project so a new row is INSERTED) the trigger will increase the salary of THIS employee who works on THIS...

8. If you were to find the angle between two planes, would it be better to use the vector equation or parametric equation. Why? Explain with a diagram. 9. For the following operations, please state...

DATABASE PROGRAMMING WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS List all the department IDs in the company, and the amount of highest income (salary plus commission_pct * salary), lowest income...

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

Write short programs as requested, the outputs of the program are required to be attached in your submission. Q 1 , ( 1 5 points ) A standalone procedure, based on Employees Table. In this question,...

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Create a Pl/SQL subprogram, which has two blocks. An outer block declares two variables named x and counter and loops four times. Inside this loop is a sub-block that also declares a variable named...

I need a JAVA program for the following PAYROLL SYSTEM with the following requirements this prograam is a part of the bigger project, So it is like one of the part in a project. Please use the...

Let y = 1/x. Find the value of dy in each case. (a) x = 1, dx = 0.5 (b) x = - 2, dx = 0.75

Leadership in the 21st Century: Some experts and researchers state that management and leadership have not fully recovered from the great recession of 2008. Do you agree or disagree with this...

CSX Corporation provides rail - based freight transportation services and transportation of intermodal containers and trailers, as well as other transportation services, such as rail - to - truck...

In Year 2, Adams Corporation discovered that it forgot to accrue interest expense of $40,000 in Year 1. This overstatement of pretax income w as material. The related income tax effect of this error...

Given the following current year information, calculate Adair Corporations retained earnings balance on December 31. Net income, $95,400 Common stock dividends declared, $32,000 Retained earnings,...

Using the same facts as in RE17-9, assume instead that Ruby declares and issues a 50% stock dividend when the stock is selling for $30 per share. Prepare the journal entry on the date of declaration...

In its first month of operations, Danielle Company made three purchases of merchandise in the following sequence: (1) 300 units at $6, (2) 400 units at $7, and (3) 200 units at $8. Assuming there are...

Pickens Corporation declares and issues a 10% stock dividend. On the date of declaration, the stock is selling for $30 per share. Assuming that there were 50,000 shares previously outstanding, with a...

Which of the following statements about determining the breakeven point is false?Group of answer choicesA. Operating income is equal to zero.B. Contribution margin less fixed costs is equal to...

The following contract was executed on August 22: Ray agrees to sell and Shaw, the representative of Todd and acting on his behalf, agrees to buy 10,000 pounds of 0.32 1 5/8 stainless steel strip...

Civil Code 1719, subdivision (a) provides in part that any person who draws a check that is dishonored due to insufficient funds shall be liable to the payee for the amount owing upon the check and...

This consolidated appeal involves respondent Department of Transportations (DOTs) interpretation of federal law governing airline service at Love Field airport. Petitioners Dallas Fort Worth...

How much is 1/2 % of $10?

1301/2 % of $455 is what amount?

Johnston Distributing, Inc. files quarterly GST returns. The purchases on which it paid the GST and the sales on which it collected the GST for the last four quarters were as follows: Calculate the...