Scribd
Upload
9 views1 page

PS Functions Query

The document contains a list of queries related to employee data and string manipulation functions. It includes tasks such as filtering employees based on name and job characteristics, counting specific letters in strings, and formatting output in a specified manner. The queries cover various aspects of employee records, including hiring dates and job titles.

Uploaded by

thethunderbird23
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
9 views1 page

PS Functions Query

The document contains a list of queries related to employee data and string manipulation functions. It includes tasks such as filtering employees based on name and job characteristics, counting specific letters in strings, and formatting output in a specified manner. The queries cover various aspects of employee records, including hiring dates and job titles.

Uploaded by

thethunderbird23
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
You are on page 1/ 1

QUERIES ON FUNCTIONS

QUERIES ON FUNCTIONS
1. List employees whose name having 4 characters
2. List employees whose job is having 7 characters
3. Find out how many times letter 'S' occurs in 'pentagonspace'
4. List the employees whose job is having last 3 characters as 'man'
5. List employees whose job is having the first 3 characters as 'man'.
6. Display all the names whose name is having exactly 1 'L'
7. Display dept names which are having letter 'O'
8. Display the output as shown below,
Scott working as a clerk earns 3000 in deptno 20
9. Calculate number of L in string 'HELLLLL'
10. Display all the employees whose job has a string 'MAN'
11. Display all the employees whose job starts with string 'MAN'
12. Display all the employees whose job ends with string 'MAN'
13. Display the first 3 characters of any string in lower case and rest everything in
upper case.
If the string is 'PENTAGON' then display this as ‘penTAGON’.
14. Display the result from the emp table as below.
SMITH is a CLERK and gets salary 2000
Here SMITH is ename column, CLERK is JOB and 2000 is the SAL column and
the rest everything is literal strings.
15. List the employees hired on a Wednesday
16. List the employees hired on a leap year
17. List the employees hired on a Sunday in the month of may

Page 1

You might also like