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

Answer Posted / aparna

select substr(ename,-5) from emp

Is This Answer Correct ?    24 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to write customizations in po

1197


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2359


can u give guidance abt packages of plsql

1644


How would you go about increasing the buffer cache hit ratio?

1954


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1613






8. Supporting AP, AR and GL?

1818


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

1595


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

1773


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1704


What is the difference between conversions and interfaces? : oracle accounts receivable

652


What is the disk migration? what is the steps involved in oracle disk migration?

719


what are the tools used for oracle 10g in real time.

1929


Can we modify approve purchase order?if yes what is navigation?

1547


Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

659


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

670