Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1236


can u give guidance abt packages of plsql

2123


default triggers available for reports

2172


What are different types of transactions in ar? : oracle accounts receivable

1236


What is an Oracle database Partial Backup?

1123


as a technical developer in oracle applications which type errors feced in your experience sofar

2287


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

17540


as a technical developer in oracle applications which type errors feced in your experience sofar

2156


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1982


1. What is PO rate variance gain and loss?

2858


What is an Oracle database Full Backup?

1095


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

1123


what are basic modules required to implement oracle application in any oraganisation?

2164


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2222


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1033