How to find last three letter of a word [message #300143] |
Thu, 14 February 2008 07:14 |
AnamikaChaudhary
Messages: 33 Registered: December 2007 Location: Mumbai
|
Member |
|
|
Hi,
i have an employee table, from that i want to get the last three letter of employee_name column.
suppose i have
king--------- ing(this is the result i want)
smith--------ith
miller-------ler
thanks
please help me
|
|
|
|
|
|
|
|
Re: How to find last three letter of a word [message #300294 is a reply to message #300262] |
Thu, 14 February 2008 23:01 |
|
Michel Cadot
Messages: 68722 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
@coleing
Once again, please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code.
Use the "Preview Message" button to verify.
Don't put solution only hint or clue as requested in OraFAQ Forum Guide, "Responding to Posts" section:
Quote: | When responding to questions, if it is obviously a student with a homework assignment or someone else just learning, especially in the homework and newbies forums, it is usually best to provide hints or clues, perhaps links to relevant portions of the documentation, or a similar example, to point them in the right direction so that they will research and experiment on their own and learn, rather than providing complete solutions to problems. In cases where someone has a real-life complex work problem, or at least it may seem complex to them, it may be best to provide a complete demo and explanation.
|
Regards
Michel
|
|
|