how to display last 5 letters from a name (take emp table
ename )

Answer Posted / 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;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the process of recievables in oracle financials. : oracle accounts receivable

662


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

659


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

1715


What is mrc and what is its use? : oracle accounts receivable

635


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

693






What do you mean by Oracle MEDIA RECOVERY?

731


Difference between negative and positive adjustments : oracle accounts receivable

628


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1707


8. Supporting AP, AR and GL?

1824


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

1963


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3994


what are the API of GL,PO,AP

1783


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1775


What is auto invoicing? : oracle accounts receivable

663


What is Tax Categories?

1634