Write query to display first name and last name as full name

Assignment Help Database Management System
Reference no: EM13850701

PART 1

1. Display first name ,last name and salary from s_emp where salary should display in the format $99,999;

2. Write query to display first name and last name as full name, salary *12+ commission_pct *salary as Total Salary from s_emp.If commission_pct *salary is null then consider it as zero use nvl function;

3. select to_char(sysdate,'YYYY') C1,to_char(sysdate,'YEAR') C2,to_char(sysdate,'MM') C3,to_char(sysdate,'DY') C4,to_char(sysdate,'DAY') C5 from dual;

4. write query to display employee name ,job, salary and revised salary from s_emp
If job is ANALYST then revised salary = salary*1.03
If job is MANAGER then revised salary = salary*1.1
If job is PRESIDENT then revised salary = salary*1.01
Else display revised salary = salary
(Use decode function)

5. display first name , last name as full name ,title , salary and revised salary from scott.s_emp table
If title is 'Sales Representative' then make revised salary = salary*1.03
If 'VP, Administration' then make revised salary = salary*1.02
If 'Warehouse Manager' then make revised salary = salary*1.1
If 'Stock Clerk' then make revised salary = salary*1.01
Else display revised salary = salary*1.05
(Use case function)

6. Display word "gOwoLFpack" in 3 ways by using Initcap , upper and lower functions;

7. select substr('ABCDEFG',0) S1,substr('ABCDEFG',1) S2,substr('ABCDEFG',4) S3,substr('ABCDEFG',4,3) S4,substr('ABCDEFG',-5) S5,substr('ABCDEFG',-5,4) S6,substr('ABCDEFG',-5,10) S7,substr('ABCDEFG',-5,-1) S8 from dual;

8. Display salary and if salary is null display commission and if both are null display 0 using coalesce function from s_emp ;

PART 2


1. Display Firstname , Lastname together with Alias as Fullname from student table.

2. Display employee name , commission and salary+10*commission as Total from scott.emp

3. Select unique deptno with job from scott.emp.

4. Select all the columns from scott.emp where sal is greater than equal to 1500

5. select only employee name from scott.emp whose employee number is less than 7782;

6. Select employee name from scott.emp where employee number is not equal to 7782;
7. Select employee name from scott.emp whose hiredate is 17th dec 1980.

8.select ename,sal,comm from scott.emp where 1=2;

9. select ename,sal,comm from scott.emp where 2=2;

10. select employee name , salary , commission from scott.emp where employee number is greater than 0

11. select ename,sal,comm from scott.emp where comm=comm;

12. Select employee name , salary and commission from scott.emp whose salary is less than equal to commission

13. By using IN operator in the where condition , display employee name , salary and job from scott.emp where jobs are in 'CLERK','SALESMAN','ANALYST'

14. By using between in where condition display employee name , salary from scott.emp where salary is between 1000 and 1500

15. Display employeenumber , employee name from scott.emp where employee name starts with letter M
16. Display employee name , salary , job from scott.emp where job is SALESMAN or PRESIDENT and salary is greater than 1500

 

 


Attachment:- New WinRAR archive.rar

Reference no: EM13850701

Previous Q& A

  List the current product lines for your chosen company

List the current product lines for your chosen company. Think of at least one idea each for new products that the company could add to its product offerings

  Explain why it is important to deliver a comprehensive scope

Explain why it is important to deliver a comprehensive scope statement at the beginning of the project. Are there any instances where the scope statement can or should be omitted

  Discusses the issues that may arise in a corporation

You are to write an essay (min 500 words) that discusses the issues that may arise in a corporation as it strives to be more entrepreneurial, and as it conducts business in general

  What circumstances wold actual government spending

Why does the budget require a forecast of the economy. Under what circumstances wold actual government spending and tax revenue fail to match the budget as approved

  Syria''s gdp recover to pre-conflict levels

How would the current GDP and GDP per capita of Syria compare to the GDP and GDP per capita of Syria before the Syrian civil war broke out? Explain why (in terms of the model presented in the chapter. What could other countries do to help Syria's..

  Discuss the potential risk for your client company

Discuss the potential risk for your client company (CISCO Healthcare IT) in Mexico, and how you will avoid this risk in the marketing plan you develop for your client (CISCO Healthcare IT)

  Broader sociological issues and concepts

Summarize the above article and compare issues seen in the article with broader sociological issues and concepts such as prejudice & discrimination, stereotypes, selective perception, scapegoating/hate crimes. Possibly also discuss the rise of is..

  Writing a business plan for a sandel business

Writing a business plan for a sandel business only 6 pages. Your group will research how to set up an online store at etsy.com. Each student will write a Business Plan for that business, using the guidelines at the Small Business Administration s..

  Show the background on the layer beneath

show the background on the layer beneath

  What types of practice procedure and processes at dick smith

What types of practices, procedures and processes at Dick Smith Electronics allowed for the identification, creation, distribution and adoption of insights and experiences by employees?

Reviews

Write a Review

 

Similar Q& A

  Sketch dfsa for identifiers-contain only letters and digits

Sketch a DFSA for identifiers which contain only letters and digits, where identifier should have at least one letter, but it need not be first character.

  Explaining concept of organizational intelligence

Need a page and half on concept of organizational intelligence. It must specifically talk about organizational intellignece being outcome of organization's efforts to gather store, process and interpret data.

  Network upgrade imagine that you are the administrator for

imagine that you are the administrator for a small accounting company which currently employees 200 people. the ceo

  Installation process between oracle 11g and oracle 10g

Create a document that will compare the installation process between Oracle 11g and Oracle 10g. Your submission document can be in the form of a MS Word document or a MS Excel spreadsheet. As long as you can adequately present your findings, the f..

  Identify the potential sale and department store transaction

Evaluate whether the use of a distributed DBMS structure is appropriate and identify the optimization techniques that should be factored in to enhance the operations of the database in your design.

  How do databases generate sales and profits

Why are databases important to business. How do databases generate sales and/or profits. What databases do you interact with, and how do they benefit you

  Verify your implementation by viewing the data dictionary

Implement the authorization table using any two suitable application models presented - Use the scripts provided to create a schema - Create three different profiles based on the criteria.

  Database triggers are utilized to record logins by users

Several times, database triggers are utilized to record logins by users. Here is the example of login trigger that inserts row into table every time a user connects.

  Write down sql dml statements which address the given

write sql dml statements that address the following requirements 1 update the employees table and give all employees

  Define the minimum and maximum cardinality

Don't worry about going through the normalization process at this point. Identify the appropriate relationships among the entities, and define the minimum and maximum cardinality of each relationship. Make some additional assumptions about the bus..

  Explain how to create query in access query wizard

Describe how to create a query in Access Query Wizard equilvant to the query: SELECT first, last, department, hours FROM payroll WHERE hours>.

  Cover topic of usability in the field of interface design

Use the Internet to locate two articles that cover the topic of universal usability in the field of interface design. Be prepared to discuss.

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!

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