Home » SQL & PL/SQL » SQL & PL/SQL » character manipulation (oracle9i)
character manipulation [message #388437] Tue, 24 February 2009 14:04 Go to next message
tq12345
Messages: 2
Registered: February 2009
Location: New Delhi
Junior Member

display details of employees having same character at the first and last position of there name?
Re: character manipulation [message #388438 is a reply to message #388437] Tue, 24 February 2009 14:09 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>display details of employees having same character at the first and last position of there name?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.

By the way, we don't do homework assignments here.
Re: character manipulation [message #388439 is a reply to message #388437] Tue, 24 February 2009 14:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First post what you already tried and why it does not fit the requirements.

clue: SUBSTR

Regards
Michel
Re: character manipulation [message #388479 is a reply to message #388437] Wed, 25 February 2009 00:34 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Hi,

Comeon Tarun, try it once..and post what have you tried...

Then we shall improve your answer

Regards,
Ashoka BL
Bengaluru
Re: character manipulation [message #388527 is a reply to message #388437] Wed, 25 February 2009 03:53 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Tarunkumar006,

HERE YOU GO.....

SELECT ename
  FROM emp
 WHERE UPPER (SUBSTR (ename, 1, 1)) = UPPER (SUBSTR (ename, -1, 1))


Now don't tell me that its so easy....

Regards,
Ashoka BL
Re: character manipulation [message #388532 is a reply to message #388527] Wed, 25 February 2009 04:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 20 February 2009 13:29
@ashoka_bl

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 usual 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, and not provide 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



ashoka_bl wrote on Mon, 23 February 2009 05:11
Michel,

I gave the hints to begin with, but he wanted the solution to copy + Paste...

I will make sure that i will follow the instructions !!

Regards,
AShoka BL

(Red color is mine) It seems you don't follow what you say.

Regards
Michel
Re: character manipulation [message #388679 is a reply to message #388437] Wed, 25 February 2009 22:35 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Hi Michel,

I couldn't resist answering that question.

Regards,
Ashoka BL
Bengaluru
Re: character manipulation [message #388685 is a reply to message #388679] Wed, 25 February 2009 22:59 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can do it yourself, you can be happy and proud to find the answer by yourself but let others (and above all beginners) feel the same things (and learn).

Regards
Michel
Previous Topic: plsql concatenate how i do that
Next Topic: ORA-19011: Character string buffer too small
Goto Forum:
  


Current Time: Sat Dec 03 09:50:04 CST 2016

Total time taken to generate the page: 0.07174 seconds