Scribd
Upload
47 views2 pages

Employee Data Queries Overview

The document outlines a series of queries related to employee and department data, focusing on various attributes such as name length, salary ranges, job characteristics, and hiring dates. It includes specific conditions for filtering and formatting employee details, such as converting names to upper or lower case, rounding salaries, and joining strings. The queries aim to extract detailed information based on specific criteria, such as character occurrences in names and job titles.

Uploaded by

shibnath
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
47 views2 pages

Employee Data Queries Overview

The document outlines a series of queries related to employee and department data, focusing on various attributes such as name length, salary ranges, job characteristics, and hiring dates. It includes specific conditions for filtering and formatting employee details, such as converting names to upper or lower case, rounding salaries, and joining strings. The queries aim to extract detailed information based on specific criteria, such as character occurrences in names and job titles.

Uploaded by

shibnath
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1.

WAQTD DETAILS OF THE EMPS WHO ARE HAVING MORE THAN 4


CHARACTERS IN THEIR NAME.
2. WAQTD DETAILS OF THE EMPS,IF EMP SALARY IS MORE THAN 3 DIGITS
AND LESS THAN 5 DIGITS.
3. WAQTD JOIN THE GIVEN STRING ‘HI’ TO ALL THE EMPLOYEES NAME.
4. WAQTD DETAILS OF EMPLOYESS WHO HAVE ODD EMPID NUMBER.
5. WAQTD NAME,SALARY OF THE EMPLOYEE, IF THE EMPLOYEE SALARY IS
IN ODD NUMBER AND THEIR EMPNO IS EVEN.
6. WAQTD NAME,JOB OF EMPS IN UPPER CASE.
7. WAQTD DNAME AND LOCATION OF EMPS IN LOWER CASE.
8. WAQTD NAME OF EMPS IN LOWER CASE AND JOB SHOULD BE INITIAL
LETTER IN UPPER REMAINING LETTERS IN LOWER ,WHO ARE HAVING
COMM.
9. WAQTD ROUND OFF THE SALARY TO THE NEAREST VALUE IN EMP
TABLE.
[Link] THE SALARY TO LOWEST VALUE IN EMPLOYEE TABLE.
[Link] DETAILS OF DEPARTMENT TABLE WHO HAVE MORE THEN 7
CHARACTERES IN THEIR LOCATION.
[Link] NAME OF EMP;OYEE WHO HAVE LAST CHAR AS ‘H’ IN THEIR
NAME.
[Link] NAME , SALARY AND HIREDATE OF EMPLOYEE IF EMPLOYEE
NAME STARTS WITH CHAR’J’.
[Link] DETAILS OF DEPT WHO HAVE 2ND CHAR AS ‘A’ IN THEIR
DEPTNAME.
[Link] FIRST HALF OF DEPTNAME.
[Link] SECOND HALF OF LOCATION.
[Link] NAME AND COMMISSION OF EMPLOYEE, IF THEY HAVE CHAR ‘I’
PRESENT IN THEIR NAME.
[Link] NAME,JOB OF THE EMPLOYEE, IF THEY HAVE CHAR ‘A’ PRESENT
ATLEAST TWICE IN THEIR NAME.
[Link] ALL THE LOCATION WHOSE DNAME STARTS WITH STRING ‘RES’.
[Link] NAME OF THE EMPLOYEES BY REPLACING CHAR ’A’ BY ‘P’ IN
THEIR NAME.
[Link] DETAILS OF THE EMPLOYEES, IF THEY HAVE CHAR ‘A’ EXACTLY
TWICE IN THEIR JOB.
[Link] NAME,JOB OF EMPS WHOSE NAME START WITH VOWELS.(ALL
THE NAMES ARE IN UPPER CASE)
[Link] DETAILS OF THE EMPLOYEES WHOSE JOBS ENDS WITH
CONSONENTS.(ALL JOBS ARE IN UPPER CASE)
[Link] FIRST 3 CHARACTERS OF NAME IN LOWER CASE AND
REMAINING IN UPPER CASE IN EMPLOYEE TABLE.
[Link] TO JOIN A STRING ‘HAPPY BIRTHDAY’ TO EMPLOYEE
NAME,WHO ARE HIRED AFTER ’01-JAN-1981’.
[Link] DETAILS OF EMPLOYEES WHO ARE HIRED IN MONTH OF JULY.
[Link] NAME AND SALARY ALONG WITH HIREDATE OF THE EMPS WHO
HIRED ON MONDAY.
[Link] DETAILS OF EMPLOYEES WHO HIRED IN THE MONTH OF
JANUARY ON WEDNESDAY AT 11 AM.
[Link] TOTAL EARNING OF ALL THE EMPS ALONG WITH NAME AND
HIREDATE.(TOTAL EARNING MEANS (SAL+COMM)).
[Link] DETAILS OF THE EMPLOYEE WHO HAVE MORE THEN 35 YEARS
OF EXPERIENCE .

You might also like