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

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 the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers  

How many segment are present in Oracle Manufacturing

0 Answers   Oracle,

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

0 Answers  

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  

Difference between negative and positive adjustments : oracle accounts receivable

0 Answers  

the user should know to which database he is connected currently in oracle

3 Answers  

Explain an ORA-01555

2 Answers  

Where would you look for errors from the database engine?

2 Answers   Fintellix,

What is chargeback invoice? How do we create it? : oracle accounts receivable

0 Answers  

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

8 Answers   Quest,

Explain the use of table functions.

0 Answers