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 the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

0 Answers   Wipro,

What are different types of receipt reversals ? Explain them : oracle accounts receivable

0 Answers  

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 Answers  

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

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,

What is the difference between oracle media recovery and crash recovery?

0 Answers  

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

4 Answers  

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

0 Answers  

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

3 Answers   HP,