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
What is the sql query to find the employee who has Nth maximum salary?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is autocashrule set? : oracle accounts receivable
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
Explain the payment term in ar. : oracle accounts receivable
3. Steps in UAT?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
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 are different types of transactions in ar? : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
How would you determine who has added a row to a table?
what is difference between inner join & nested query or subqueries
as a technical developer in oracle applications which type errors feced in your experience sofar
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable