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

types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  

How can you enable a trace for a session?

2 Answers  

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,

what is shared memory?

1 Answers   IBM,

Explain the process of recievables in oracle financials. : oracle accounts receivable

0 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  

When a user process fails, what background process cleans up after it?

1 Answers  

what is sql*loader parameters and where we will use it.

1 Answers   Accenture,

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

0 Answers  

what are basic modules required to implement oracle application in any oraganisation?

0 Answers