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
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
what is difference between inner join & nested query or subqueries
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What is supporting issues GL AP and AR?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
HOW TO SPOT AHIERARCHY?
How would you determine what sessions are connected and what resources they are waiting for?
What is the use of lockboxes? : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
Explain how to close periods in ar. : oracle accounts receivable
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
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
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.