how to display last 5 letters from a name (take emp table
Answers were Sorted based on User's Feedback
Answer / aparna
select substr(ename,-5) from emp
|Is This Answer Correct ?||24 Yes||2 No|
Answer / tanmay
select substr(ename,-5)as name from emp
|Is This Answer Correct ?||4 Yes||1 No|
Answer / samrendra
select substr(empname,-5)from emp
|Is This Answer Correct ?||4 Yes||2 No|
Answer / david
their is no any keyword like "right" as u used in ur
|Is This Answer Correct ?||2 Yes||0 No|
Answer / kd
"select substr(ename,-5)as name from emp " is not right
because you will get no name if the ename is shorter than 5
select reverse (substr (reverse(ename), 1, 5))
|Is This Answer Correct ?||0 Yes||0 No|
Answer / swati
select right(ename,5) as name from emp
|Is This Answer Correct ?||6 Yes||15 No|
What Are Cross Validation & Adi?
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
Compare and contrast TRUNCATE and DELETE for a table.
A scenario for amount correction & how to use amount correction functionality in AP invoices
When creating a user, what permissions must you grant to allow them to connect to the database?
what is difference between inner join & nested query or subqueries
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is db_recovery_file_dest in oracle? When do you need to set this value?
You have just compiled a PL/SQL package but got errors, how would you view the errors?
Explain how to close periods in ar. : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?