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

Answer Posted / tanmay

select substr(ename,-5)as name from emp

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1918


what is difference between inner join & nested query or subqueries

2491


TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

2841


What is supporting issues GL AP and AR?

2000


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

719






How do you create a credit note against an invoice? : oracle accounts receivable

654


HOW TO SPOT AHIERARCHY?

1851


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

1617


What is the use of lockboxes? : oracle accounts receivable

663


difference of using cursor for loop and open,fetch,close.which one is better

1257


Explain how to close periods in ar. : oracle accounts receivable

717


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

1774


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

16389


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2062


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.

1861