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 are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
can u give guidance abt packages of plsql
default triggers available for reports
What are different types of transactions in ar? : oracle accounts receivable
What is an Oracle database Partial Backup?
as a technical developer in oracle applications which type errors feced in your experience sofar
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
as a technical developer in oracle applications which type errors feced in your experience sofar
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
1. What is PO rate variance gain and loss?
What is an Oracle database Full Backup?
Explain the process of recievables in oracle financials. : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable