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 the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

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

0 Answers   L&T,

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

0 Answers  

How many segment are present in Oracle Manufacturing

0 Answers   Oracle,

the user should know to which database he is connected currently in oracle

3 Answers  

What is an Oracle database Full Backup?

0 Answers  

What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,

How would you determine who has added a row to a table?

0 Answers  

How would you determine what sessions are connected and what resources they are waiting for?

0 Answers  

How would you go about increasing the buffer cache hit ratio?

0 Answers  

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

Give two examples of how you might determine the structure of the table DEPT.

2 Answers