Question: Write a PL/SQL program to retrieve the emp table and then display the salary

Write a PL/SQL program to retrieve the emp table and then display the salary

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!

Q:

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,...

Q:

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

Q:

Using this table: CREATE TABLE department ( DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAME VARCHAR2(50) NOT NULL UNIQUE, LOCATION VARCHAR2(20) NOT NULL); INSERT INTO department VALUES(10,...

Q:

Please help on these questions that we are facing difficulty. Thank you. 1. Write a PL/SQL program to check whether specified employee is present in EMP table or not. Accept emp no from user. If...

Q:

Create both the tables Branch and Supervisor with appropriate attribute names, primary key, foreign key and data type. Insert the above records into Branch and Supervisor tables. Display all the...

Q:

Create both the tables Branch and Supervisor with appropriate attribute names, primary key, foreign key and data type. Insert the above records into Branch and Supervisor tables. Display all the...

Q:

-- echo Building demo tables. Please wait. DROP TABLE EMP CASCADE CONSTRAINTS; DROP TABLE DEPT; DROP TABLE SALGRADE; DROP TABLE Prod CASCADE CONSTRAINTS; DROP TABLE Vend; CREATE TABLE DEPT ( DEPTNO...

Q:

a) Explain the following terms as used in real estate appraisals i. Value in use ii. iii. Liquidation value Insurable value b) Describe the cost approach of real estate valuation c) Explain the...

Q:

Question #1: W hen you are grouping what does the where "do and" what does the having do? Question #2: I have a table with idno, name, dept,jobcode, and salary. Write the code to group by jobcode...

Q:

1. Write a PL/SQL block to ask the user to enter the students marks and determine the GRADE (using IF statements) according to the following criteria. Your output should display the following message...

Q:

An ad for Levi's jeans contained information about The Bay department stores where the jeans could be purchased. This ad was most likely an example of which type of advertising? A) Comparative B)...

Q:

You are the audit manager of Samson & Co and are reviewing the key issues identified in the files of two audit clients. Panto Industries Co (Panto) Pantos year-end was 31 March 2015 and the draft...

Q:

Differentiate. y = t ( t - 3 ) 2 y ' = Use the General Power Rule to find the derivative of the function. y = 6 5 x 2 + 7 3 y ' =

Q:

A sample data set has a mean of 57 and a standard deviation of 11. Determine whether each of the following sample measurements is outliers. a. 65 b. 21 c. 72 d. 98

Q:

Compare the z -scores to decide which of the following x values lie the greatest distance above the mean and the retest distance below the mean: a. x = 100, = 50, = 25 b. x = 1, = 4, = 1 c. x =...

Q:

Compute the z-score corresponding to each of the following values of x: a. x = 40, s = 5, = 30 b. x = 90, = 89, = 2 c. = 50, = 5, x = 50 d. s = 4, x = 20, = 30

Q:

However, this problem is self-contained because all the facts are reproduced as follows: Company P acquired a 100% voting interest in Company S for $150 million cash at the start of the year....

Q:

This modifies and extends Problem 17-A2. However, this problem is self-contained because all the facts are reproduced. Poseidon Publishing Company acquired all the common shares of Neptune Book...

Q:

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

Q:

Help Tony write his job description. P-96

Q:

How does TeamFuel's new delivery process effect human resource planning in the organization? P-96

Q:

Describe the work of Schaffner-Irvin in terms of a SWOT analysis. P-96