User Account

All Pages

Write a pl/sql block and declare a variable v_sal

Assignment Help PL-SQL Programming
Reference no: EM1394274

Write a PL/SQL block and declare a variable v_sal of the type NUMBER. Include the following statement in the Execution section:

SELECT MAX(salary)

    INTO v_sal

  FROM employees;

 Display the maximum salary in the Employees table. 

Submit the code of the PL/SQL block.

Reference no: EM1394274

Questions Cloud

Illustrate what was bps strategy prior : Conduct research also provide an analysis of BP's strategy before the accident occurred using appropriate strategic frameworks.
Determine sample size-standard iq points : A standard IQ test has mean of 98 and a standard deviation of 16. We want to be 99% certain that we are 8 IQ points of the true mean. Determine the sample size.
Write a double spaced mla format report : South Korea also USA are two countries which have strong relations with each other. Illustrate what strategic issues do you envision for your business in which area.
Sample size-noise levels at urban hospitals : A researcher is interested in estimating the noise levels in decibels at area urban hospitals. She wants to be 99% confident that her estimate is correct.
Write a pl/sql block and declare a variable v_sal : Write a PL/SQL block and declare a variable  v_sal  of the type NUMBER. Include the following statement in the Execution section:
Sample size-standard iq points : A standard IQ test has mean of 98 and a standard deviation of 16. We want to be 99% certain that we are 8 IQ points of the true mean. Determine the sample size.
Sample size-birth weight of infants : A health care professional wishes to estimate the birth weight of infants. How large a sample must she select if she desires to be 90% confident that the true mean is within 6 ounces of the sample mean?
Comparing percentages with different sample sizes : A new group comes along and that only has 5 people. Their weights are also measured initially and after 9 weeks. What would be the most accurate methodology for determining the percentage of weight loss for this new group?
Synthesis of purines and specific pyrimidine : THFA is an important contributor to the synthesis of both purines and a specific pyrimidine. Which pyrimidine? Why does a block in the enzyme dihydrofolate reductase (DHFR) have negative consequences on nucleotide biosynthesis?

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Write sql statement which creates stored procedure

Write SQL statement which creates stored procedure with one int input parameter. Stored procedure selects supplierId field and total of all Count field values for each group of supplierId's from Part table.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

  Write sql statement to create stored procedure

Write SQL statement which creates stored procedure with one int input parameter. The stored procedure selects the supplierId field and the total of all Count field values for each group of supplierId's from the Part table.

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write sql commands to implement profile

Write SQL commands which would implement this profile. Next, write query that would list profile, profile resource name, and limit value for the new profile.

  Write pl-sql block that displays last name

Write PL/SQL block which displays last name and salary of following people. Each of these can be done separately as PL/SQL, first to test and get output lines.

  Write sql statement-display major of student-no duplications

Write a SQL statement to display the Major of the student with no duplications. Write a SQL statement to display the First and Last name of students who live in the Zip code 88888.

  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.

  Write sql create table statement to create pet table

Write an SQL CREATE TABLE statement to create the PET table without referential integrity constraint on OwnerID in PET.

  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.

  Write sql statement to create view

Write a SQL Statement to create a View called vwEmployeeTerritories that will do the following: Return all Employees and their Territories (use INNER JOIN).

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