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

Explain how to close periods in ar. : oracle accounts receivable

0 Answers  

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

0 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,

How do you use trigger to create mutating state of table

2 Answers   TCS,

what is different between inline query,subquery& corelated query?

8 Answers   Quest,

please explain about oracle

1 Answers  

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

0 Answers   TCS,

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

0 Answers  

What is an Oracle database Partial Backup?

0 Answers  

statement string in open is null or 0 length ORA-40735

1 Answers   RoboSoft, Unilog,

How would you determine the time zone under which a database was operating?

1 Answers  

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

4 Answers