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
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
How would you go about increasing the buffer cache hit ratio?
How would you determine what sessions are connected and what resources they are waiting for?
What view would you use to determine free space in a tablespace?
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
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is an Oracle database Partial Backup?
types of receipts and detail desription about recipts and tables effected by receipts?
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
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
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
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.
Where in the Oracle directory tree structure are audit traces placed?
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