how to display last 5 letters from a name (take emp table ename )

Categories >> Software >> Databases >> Oracle >> Oracle AllOther
Suggest New Category

how to display last 5 letters from a name (take emp table
ename )

Question Posted / malli

6 Answers
10267 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to display last 5 letters from a name (take emp table ename )..

Answer / aparna

select substr(ename,-5) from emp

Is This Answer Correct ?

24 Yes

2 No

how to display last 5 letters from a name (take emp table ename )..

Answer / tanmay

select substr(ename,-5)as name from emp

Is This Answer Correct ?

4 Yes

1 No

how to display last 5 letters from a name (take emp table ename )..

Answer / samrendra

select substr(empname,-5)from emp

Is This Answer Correct ?

4 Yes

2 No

how to display last 5 letters from a name (take emp table ename )..

Answer / david

@swati ...

their is no any keyword like "right" as u used in ur
answer's statement......

david

Is This Answer Correct ?

2 Yes

0 No

how to display last 5 letters from a name (take emp table ename )..

Answer / kd

"select substr(ename,-5)as name from emp " is not right
because you will get no name if the ename is shorter than 5
letters.
right way:
select reverse (substr (reverse(ename), 1, 5))
from emp;

Is This Answer Correct ?

0 Yes

0 No

how to display last 5 letters from a name (take emp table ename )..

Answer / swati

select right(ename,5) as name from emp

Is This Answer Correct ?

6 Yes

15 No

Post New Answer

More Oracle AllOther Interview Questions

Olap tools

0 Answers

HOW TO SPOT AHIERARCHY?

0 Answers

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers Oracle,

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

0 Answers

Could you please let me know the interfaces in OM / FA??

0 Answers Oracle,

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers

what is shared memory?

1 Answers IBM,

What command would you use to create a backup control file?

1 Answers

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers jusco,

What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers

i have marks in table,how to find total?

1 Answers

How do you resize a data file?

2 Answers

For more Oracle AllOther Interview Questions Click Here