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
Explain the process of recievables in oracle financials. : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is mrc and what is its use? : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What do you mean by Oracle MEDIA RECOVERY?
Difference between negative and positive adjustments : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
8. Supporting AP, AR and GL?
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
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
what are the API of GL,PO,AP
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is auto invoicing? : oracle accounts receivable
What is Tax Categories?