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  

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

0 Answers  

How client makes connection with server in client/server architecture?

1 Answers   CA,

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers  

What is supporting issues GL AP and AR?

0 Answers   Oracle,

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

3 Answers  

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers  

which one is currently in used software cmpanies.

0 Answers  

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

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

4 Answers  

What do you mean by Oracle MEDIA RECOVERY?

0 Answers  

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

1 Answers