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 auto invoicing? Explain : oracle accounts receivable

0 Answers  

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers  

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  

key flexfield structure

0 Answers   Infosys,

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

0 Answers  

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  

Name two files used for network connection to a database.

1 Answers  

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

1 Answers  

What is the sql query to find the employee who has Nth maximum salary?

2 Answers  

How can you enable a trace for a session?

2 Answers  

deference between & and &&

2 Answers   Mphasis,

What is cardinality?

4 Answers