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

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

645


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

680


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

1957


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

1614


What view would you use to determine free space in a tablespace?

1783






I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

1829


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

731


What is an Oracle database Partial Backup?

698


types of receipts and detail desription about recipts and tables effected by receipts?

1629


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

1768


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

16373


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

1638


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

1879


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

2128


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

1961