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 importance of batch source set up in ar? : oracle accounts receivable

0 Answers  

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

1 Answers   RoboSoft, Unilog,

difference of using cursor for loop and open,fetch,close.which one is better

0 Answers   Accenture,

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers  

How do you use trigger to create mutating state of table

2 Answers   TCS,

Name a tablespace automatically created when you create a database.

3 Answers   HCL,

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

0 Answers  

Describe the P2P cycle ?

1 Answers  

what are the API of GL,PO,AP

0 Answers  

Explain about party and customer in ar : oracle accounts receivable

0 Answers  

What Are Cross Validation & Adi?

0 Answers   Oracle,

What background process refreshes materialized views?

1 Answers