User Account

All Pages

Write a pl-sql block

Assignment Help PL-SQL Programming
Reference no: EM13127281

Write a PL/SQ block to do the following:

Select the average salary of all employees in department number 20.

If the average salary is less than 5000, then increase the salary of all employees in that Department by 10% (using an UPDATE command). If the average salary is greater than 5000, then display the message ‘No action needs to be taken'.

Reference no: EM13127281

Questions Cloud

Values of some complex integrals : Find the value of the integral of g(z) around the circle |z - i| = 2 in the positive section when g(z) = 1/(z^2+4)
Calculate difference in pressure between methane & ideal gas : 13.00 moles of gas are in a 5.00 L tank at 22.6 C. Calculate the difference in pressure between methane and an ideal gas under these conditions. The van der Waals constants for methane are a = 2.300 L^2*atm/mol2 and b = 0.0430 L/mol.
Find percentage of defective washers produced by machine : Determine the percentage of defective washers produced by this machine, assuming the diameters are normally distributed.
Find best point estimate of population mean : The mean to be $19 and the standard deviation to be 6.8. Find the best point estimate of the population mean and the 95% confidence interval of the population mean.
Write a pl-sql block : Write a PL/SQ block - Select the average salary of all employees in department number 20.
What is the mole fraction of ammonia : An aqueous solution is 30.0 % by mass ammonia, NH3, and has a density of 0.892 g/mL.The mole fraction of ammonia in the solution is?
Important information about finding expressions : Important information about Finding expressions for the partial molar volumes at T and P, The molar volume (cm^3 mol^-1) of a binary liquid mixture at T and P is given by: V = 120x1 + 70x2 + (15x1 + 8x2)x1x2 (a) Find expressions for the partial mo..
Compute warrens actual return on plan assets : For Warren Corporation, year-end plan assets were $2,000,000. At the beginning of the year assets were $1,780,000. During the year, contributions to the pension fund were $120,000, and benefits paid were $200,000. Compute Warren's actual return on..
Essay about the condition of secondary education : Write a 500-word illustration essay about the Condition of Secondary Education.

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Draw an entity-relationship diagram

Draw an Entity-Relationship Diagram (ERD) for the data storage requirements of a business described in the case study and Data Model Transformation.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write down sql needed to create employee table

Write down SQL needed to create employee table containing the following data: employeeID, text, length of 5, primary key lastName, text, length of 25

  Write command to list all the employees in year

Write the command to list all the employees hired in 2003 and 2004. Sort the rows by the hire_date column in descending order.

  Select statement to return one row

Write a SELECT statement that returns one row for each general ledger account number which contains three columns.

  Write sql statement to create user defined function

Write SQL statement which creates user defined function which returns int value. This int return value is obtained by deducting the lowest Count field value from the highest Count field value of Part table.

  Write sql statement to produce single column

Write an SQL statement to produce a single column called ItemLocation that combines the SKU_Description,the phrase "is located in."

  Design new transaction by sql statements

Code SQL statements to update view as follows: change spelling of Mark Tobey to Mark Toby. Design new Transaction for Mark Toby. Suppose you have essential transaction, work, and customer data.

  Create program to enter first and second number

Create a program that enters first and a second number. The first and second number that will be entered should be computed in halves, quarter, double, and square.

  Provide four queries to answer questions asked by end users

Explain how you will go about developing this database. Provide at least four queries that answer some of the questions asked by the end users.

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd