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




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

What Are Cross Validation & Adi?

0 Answers   Oracle,


hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers  


Compare and contrast TRUNCATE and DELETE for a table.

3 Answers  


A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  


When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers  






what is difference between inner join & nested query or subqueries

0 Answers  


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

0 Answers  


What is db_recovery_file_dest in oracle? When do you need to set this value?

0 Answers  


You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  


Explain how to close periods in ar. : oracle accounts receivable

0 Answers  


What is the use of lockboxes? : oracle accounts receivable

0 Answers  


You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1804)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)