how to display last 5 letters from a name (take emp table
Answers were Sorted based on User's Feedback
Answer / aparna
select substr(ename,-5) from emp
|Is This Answer Correct ?||24 Yes||2 No|
Answer / tanmay
select substr(ename,-5)as name from emp
|Is This Answer Correct ?||4 Yes||1 No|
Answer / samrendra
select substr(empname,-5)from emp
|Is This Answer Correct ?||4 Yes||2 No|
Answer / david
their is no any keyword like "right" as u used in ur
|Is This Answer Correct ?||2 Yes||0 No|
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
select reverse (substr (reverse(ename), 1, 5))
|Is This Answer Correct ?||0 Yes||0 No|
Answer / swati
select right(ename,5) as name from emp
|Is This Answer Correct ?||6 Yes||15 No|
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
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.
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
Explain the difference between a data block, an extent and a segment.
Give the two types of tables involved in producing a star schema and the type of data they hold.
how to create an user in oracle 10g.please give me an example..
What is Tax Categories?
Whats the purpose of using Nextval while creating the sequence.
How do you use trigger to create mutating state of table
How to find locks exists in a table or not?
WHAT IS CARTESIAN PRODUCT?