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 shared memory?

1 Answers   IBM,

What is supporting issues GL AP and AR?

0 Answers   Oracle,

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers  

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

0 Answers  

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

0 Answers  

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

7 Answers  

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

1 Answers  

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers  

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

0 Answers  

what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,