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

Answer Posted / swati

select right(ename,5) as name from emp

Is This Answer Correct ?    6 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where in the Oracle directory tree structure are audit traces placed?

2123


i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

1851


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1590


What is chargeback invoice? How do we create it? : oracle accounts receivable

725


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

734






which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1914


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1833


What Are Cross Validation & Adi?

689


What is the difference between oracle media recovery and crash recovery?

671


Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1239


What is the use of lockboxes? : oracle accounts receivable

656


Why more redos are generated when the oracle database is in begin backup mode?

665


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

16363


What is the mandatory setup in cyclecount ?

2186


How would you determine what sessions are connected and what resources they are waiting for?

1614