Home » SQL & PL/SQL » SQL & PL/SQL » UPPER(STRING) (SQL 10G)
UPPER(STRING) [message #308369] Mon, 24 March 2008 02:44 Go to next message
sandipshahare
Messages: 21
Registered: March 2008
Location: Pune
Junior Member
I have a string and i want to convert specific words from string into initcap;

v_string='Subject=abcdFrom=raj@gmail.comBcc=satish@rediff.comCc=rahul@gmail.com';
the out put should be

'SUBJECT=abcdFROM=raj@gmail.comBCC=satish@rediff.comCC=rahul@gmail.com'


I want to convert the words Subject,From,Bcc,Cc into uppercase using Sql query;

The values assign to these words may be different in each case.

Please sugggest the way for this.
Re: UPPER(STRING) [message #308374 is a reply to message #308369] Mon, 24 March 2008 02:56 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT an expert question. Why did you post this in expert forum and not in newbie one?

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them.

Regards
Michel
Previous Topic: To see inserted data at every step in a pipeline report
Next Topic: Update Query
Goto Forum:
  


Current Time: Mon Dec 05 21:02:33 CST 2016

Total time taken to generate the page: 0.29267 seconds