SQL Plus - To display the all employee name with end of ‘S’ without using like operator ?

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 121 of 132

To display the all employee name with end of ‘S’ without using like operator ?

Total Answers and Comments: 5

Last Update: October 12, 2007 Asked by: ddkdhar

Sponsored Links

Best Rated Answer

—

Submitted by: Faizal

Also, u can try this way:

select ename from emp where lower(substr(ename,length(ename),1))='s';

Cheers - Faizal

Above answer was rated as good by the following members:
vara.vanam, shiiva

March 07, 2007 20:42:47

neetus

RE: To display the all employee name with end of ‘S’ w...

select employee_name from employees where substr(employee_name -1 1) 'S';

Is this answer useful? Yes | No

March 08, 2007 19:01:48

Faizal

RE: To display the all employee name with end of ‘S’ w...

Also u can try this way:

select ename from emp where lower(substr(ename length(ename) 1)) 's';

Cheers - Faizal

Is this answer useful? Yes | No

1 0

Overall Rating: +1

March 22, 2007 00:50:57

Raj

RE: To display the all employee name with end of ‘S’ w...

select ename from emp where substr(ename -1) 'S';

Is this answer useful? Yes | No

September 06, 2007 06:22:31

roosu

RE: To display the all employee name with end of ‘S’ w...

Hi
Try this:

SELECT * FROM emp WHERE ename LIKE ' S'

Is this answer useful? Yes | No

0 1

Overall Rating: -1

October 12, 2007 07:32:14

pradeep bhargav

RE: To display the all employee name with end of ‘S’ w...

select employee_name from employees where substr(first_name -1) 's'

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank