Answer / aparna

select substr(ename,-5) from emp

Answer / tanmay

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

Answer / samrendra

select substr(empname,-5)from emp

Answer / david

@swati ...

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

david

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;

Answer / swati

select right(ename,5) as name from emp

What is index? How many types of indexes?

2 Answers   HCL,

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers  

Can we modify approve purchase order?if yes what is navigation?

0 Answers   L&T,

whats the difference between join command and Cartesian product using example?

1 Answers  

How to clone the database using RMAN back

0 Answers  

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

0 Answers   Oracle,

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  

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  

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

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

0 Answers  

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

4 Answers  

can u give guidance abt packages of plsql

0 Answers   Mphasis,