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

how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)

1 Answers  


i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

0 Answers  


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers  


write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  


Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,






Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  


how to create an user in oracle 10g.please give me an example..

1 Answers  


What is Tax Categories?

0 Answers  


Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,


How do you use trigger to create mutating state of table

2 Answers   TCS,


How to find locks exists in a table or not?

1 Answers   HCL,


WHAT IS CARTESIAN PRODUCT?

2 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)