OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Need a query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need a query [message #189889]

Mon, 28 August 2006 06:13

lotus14
Messages: 5
Registered: February 2005

Junior Member

Hi friends,

I need a query to display the name "Devanand Santhosh Rao" as D.S.Rao.

Please help me.

Report message to a moderator

Re: Need a query [message #189892 is a reply to message #189889]

Mon, 28 August 2006 06:32

gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA

Senior Member

select substr('Devanand Santhosh Rao',1,1)||'.'||substr('Devanand Santhosh Rao',instr('Devanand Santhosh Rao',' ',1,1)+1,1)||'.'||substr('Devanand Santhosh Rao',instr('Devanand Santhosh Rao',' ',1,2)+1) from dual;

PS: this query not generic one. it will produce accurate result if you have given three word, otherwise not. so change accordingly for requirement

Thanks,
Thangam

Report message to a moderator

Re: Need a query [message #189897 is a reply to message #189889]

Mon, 28 August 2006 07:06

ebrian
Messages: 2794
Registered: April 2006

Senior Member

SQL> select translate(substr(name,1,instr(name,' ',-1)),' abcdefghijklmnopqrstuvwxyz','.') ||
	substr(name,instr(name,' ',-1)+1) "Name" from (
	select 'Devanand Santhosh Rao' name from dual);


Name
-------
D.S.Rao

Report message to a moderator

Previous Topic:	update if exists else insert
Next Topic:	Question about cursors (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 06:23:39 CST 2024